Tutorialspoint.dev

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
    <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:



This article is attributed to GeeksforGeeks.org

leave a comment

code

0 Comments

load comments

Subscribe to Our Newsletter