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 )

Connecting to %s

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

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
  • 280,991 hits
IndiBlogger
malliktalksjava.wordpress.c...
70/100