How to Create Excel file in Java using POI API


import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class CreateExcelFile {

public static final String FILE_NAME = “D:\\test.xls”;

public void createExcelFile(String filename) {

try {

HSSFWorkbook hwb = new HSSFWorkbook();

HSSFSheet sheet = hwb.createSheet(“Sheet1”);


HSSFRow rowhead = sheet.createRow((short) 0);

rowhead.createCell((short) 0).setCellValue(“S.No.”);

rowhead.createCell((short) 1).setCellValue(“Emp ID”);

rowhead.createCell((short) 2).setCellValue(“EMP Name”);

rowhead.createCell((short) 3).setCellValue(“Dept”);


rowhead = sheet.createRow((short) 1);

rowhead.createCell((short) 0).setCellValue(“1”);

rowhead.createCell((short) 1).setCellValue(“EMP1”);

rowhead.createCell((short) 2).setCellValue(“Mallik”);

rowhead.createCell((short) 3).setCellValue(“Java”);

FileOutputStream fileOut = new FileOutputStream(filename);



System.out.println(“Your excel file has been generated!”);

} catch (Exception ex) {





public static void main(String[] args) {

CreateExcelFile excelFile = new CreateExcelFile();




One thought on “How to Create Excel file in Java using POI API

  1. Ryan Mike January 8, 2014 / 9:27 am

    There is another java API available using which you can create excel file known as Aspose.Cells for JavaAPI. This API offers many other features also. Try it.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.