Home Tutorials Poi Create Simple Excel(.xls) document using Apache POI
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Create Simple Excel(.xls) document using Apache POI

Advertisement
In this section, you will learn how to create a Simple Excel sheet having .xls extension using Apache POI library.

Create Simple Excel(.xls) document using Apache POI

In this section, you will learn how to create a Simple Excel sheet having .xls extension using Apache POI library.

In the given below example, we will going to create a simple excel document having one sheet named as "FIRST SHEET" which have values on the first row and first column. The row contains text "FIRST SHEET".

In the below example, i have used Apache POI version 3.7. For downloading the above library click here.

The Code is given below :

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class CreateSimpleExcelDemo {
public static void main(String[] args) {
//
// Creating an instance of HSSFWorkbook.
//
HSSFWorkbook workbook = new HSSFWorkbook();

//
// Create two sheets in the excel document and name it First Sheet and
// Second Sheet.
//
HSSFSheet firstSheet = workbook.createSheet("FIRST SHEET");
HSSFSheet secondSheet = workbook.createSheet("SECOND SHEET");

HSSFRow rowA = firstSheet.createRow(0);
HSSFCell cellA = rowA.createCell(0);
cellA.setCellValue(new HSSFRichTextString("FIRST SHEET"));

HSSFRow rowB = secondSheet.createRow(0);
HSSFCell cellB = rowB.createCell(0);
cellB.setCellValue(new HSSFRichTextString("SECOND SHEET"));

//
// To write out the workbook into a file we need to create an output
// stream where the workbook content will be written to.
//
FileOutputStream fos = null;
try {
fos = new FileOutputStream(new File("xls/CreateExcelDemo.xls"));
workbook.write(fos);
} catch (IOException e) {
e.printStackTrace();
} finally {
if (fos != null) {
try {
fos.flush();
fos.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
}

Output :

The Content of the first sheet of "CreateExcelDemo.xls" is given below :

            A
1 FIRST SHEET  

Download Source Code

Advertisements

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: August 9, 2011

Ask Questions?    Discuss: Create Simple Excel(.xls) document using Apache POI  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com