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:

1. Create a JAVA Maven project
2. 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>

3. 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 Java Foundation and Collections concepts with the Fundamentals of Java and Java Collections Course at a student-friendly price and become industry ready. To complete your preparation from learning a language to DS Algo and many more,  please refer Complete Interview Preparation Course.