Creating Sheets in Excel File in Java using Apache POI

For a given Excel file (here Geeks.xlsx), it is needed to create sheets in it.

Steps:

Create a JAVA Maven project

Add dependency in pom.xml file

<!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
<dependency> 
      <groupId>org.apache.poi</groupId> 
      <artifactId>poi</artifactId> 
      <version>3.12</version> 
    </dependency> 
    <dependency> 
      <groupId>org.apache.poi</groupId> 
      <artifactId>poi-ooxml</artifactId> 
      <version>3.12</version> 
    </dependency> 

Create a class in javaResource folder

import java.io.*; 
import org.apache.poi.hssf.usermodel.HSSFWorkbook; 
import org.apache.poi.ss.usermodel.Sheet; 
import org.apache.poi.ss.usermodel.Workbook; 
  
public class CreateSheet { 
    public static void main(String[] args)  
      throws FileNotFoundException, IOException 
    { 
  
        // Creating Workbook instances 
        Workbook wb = new HSSFWorkbook(); 
  
        // An output stream accepts output bytes and sends them to sink. 
        OutputStream fileOut = new FileOutputStream("Geeks.xlsx"); 
          
        // Creating Sheets using sheet object 
        Sheet sheet1 = wb.createSheet("Array"); 
        Sheet sheet2 = wb.createSheet("String"); 
        Sheet sheet3 = wb.createSheet("LinkedList"); 
        Sheet sheet4 = wb.createSheet("Tree"); 
        Sheet sheet5 = wb.createSheet("Dynamic Programing"); 
        Sheet sheet6 = wb.createSheet("Puzzles"); 
          
  
System.out.println("Sheets Has been Created successfully"); 
  
        wb.write(fileOut); 
    } 
} 

Output:

Sheets Has been Created successfully

Here 6 sheets has been created in geeks.xlsx file:

Attention reader! Don’t stop learning now. Get hold of all the important DSA concepts with the DSA Self Paced Course at a student-friendly price and become industry ready.

My Personal Notes

Recommended Posts: