How to Write data into Excel using Apache POI API?

In this tutorial we are going to understand how to write data into an excel sheet.

Program to Write data into Excel using Apache POI api

Step 1 : Importing of necessary packages

// package from Fileinput

import java.io.FileInputStream;

// packages from apache POI

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

Step 2 : To read the data from Excel, we are using FileInputStream

Path refers to location of the excelsheet.

FileInputStream ExcelFile = new FileInputStream(path);

Step 3 : Open the existing workbook instance of xlxs file

XSSFWorkbook ExcelWBook = new XSSFWorkbook(ExcelFile);

Step 4 : Access the existing worksheet of xlsx file, in this instance it is “Sheet1”

XSSFSheet ExcelWSheet = ExcelWBook.getSheet(“Sheet1”);

Step 5 : Setting the Row Number as 2 and Column number as 1

int RowNum = 2;

int ColNum = 1;

Step 6 : Will create a specific row based on the parameter passed.

XSSFRow Row = ExcelWSheet.createRow(RowNum);

Step 7 : Will create a specific column based on the

parameter passed.

XSSFCell Cell = Row.createCell(ColNum);

Step 8 : Setting the cell value in the excel sheet

Cell.setCellValue(data);

Step 9 : Write the data into cell in the excel sheet.

ExcelWBook.write(new FileOutputStream(path));

Step 10 : Close the excel workbook.

ExcelWBook.close();

Program :