Course Curriculum

Creating Sheets in Excel File in Java using Apache POI

Creating Sheets in Excel File in Java using Apache POI

For a given Excel file (here Prutor.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("Prutor.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);
}
}
result:

Sheets Has been Created successfully

(Next Lesson) How to start learning Java