Write to an MS Excel File using Apache POI

Overview

This tutorial outlines the steps to create an MS Excel File using Apache POI. We can create an object of Workbook using the following statement:

Workbook wb = new XSSFWorkbook();

Create a new sheet in the Workbook using the statement. Sample Sheet is the sheet name:

Sheet sheet = wb.createSheet(“Sample Sheet”);

Now to create a Row, we can use the following statement. We need to pass the index of the row. Row index starts with 0.

Row row = sheet.createRow(0);

Create a cell. Cell index also starts with 0. The first cell in the Excel sheet is identified by row 0, cell 0.

Cell cell=row.createCell(0);

To write to the cell:

cell.setCellValue(“Sample Data”);

Sample Code

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import 
org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/*********************************************
 * Sample Java Program to create Excel file
 * with Sample Data.
 * 
 * www.TestingDocs.com - Apache POI Tutorials
 * 
 *********************************************/
public class WriteExcel {

 public static void main(String[] args) throws 
InvalidFormatException, IOException{
 String fileName = "TDocs.xlsx";
 Workbook wb = new XSSFWorkbook();
 Sheet sheet = wb.createSheet("Sample Sheet");
 Row row = sheet.createRow(0);
 Cell cell=row.createCell(0);
 cell.setCellValue("www.TestingDocs.com");
 FileOutputStream fos=new 
FileOutputStream(fileName);
 wb.write(fos);
 fos.close();
 System.out.println("Check the File 
in the Project Root.");
 }}