How to Create Excel file in Java using POI API



import java.io.FileOutputStream;


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);

hwb.write(fileOut);

fileOut.close();

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


} catch (Exception ex) {

System.out.println(ex);

ex.printStackTrace();

}

}

public static void main(String[] args) {

CreateExcelFile excelFile = new CreateExcelFile();

excelFile.createExcelFile(FILE_NAME);

}

}

Advertisements
About

I born in Good cultural place called India. My family is traditional family. We fallow all Indian traditions.

Tagged with: , , , , ,
Posted in POI API
One comment on “How to Create Excel file in Java using POI API
  1. Ryan Mike says:

    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:

WordPress.com Logo

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

Google+ photo

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

Twitter picture

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

Facebook photo

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

w

Connecting to %s

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 678 other followers

Calendar
September 2012
M T W T F S S
« Jul   Oct »
 12
3456789
10111213141516
17181920212223
24252627282930
Mallikarjun Gunda

This is Mallikarjun Gunda, I am working as a software professional. Blogging is my Passion. This blog contains the posts on Java related technologies and programming languages. I am happy to share my knowledge through the blogs.

Blog Stats
  • 265,562 hits
IndiBlogger
malliktalksjava.wordpress.c...
70/100