In this program,
we are going to create a new excel sheet using java .You can create
any number of new excel sheets in a excel file.
To create a excel
sheet we can use third party APIs .The name of this API is POI. This
API is provided by the Apache Jakarta(Jakarta POI - Java API To
Access Microsoft Format Files ) Tomcat. You can download POI.jar form
Apache Jakarta Project.It is open source.
OLE 2 compound
Document Format is based on files including most Microsoft office
files as XLS and DOC.
The package we
need to import is java.io.InputStream,
org.apache.poi.hssf.usermodel.HSSFSheet and
org.apache.poi.hssf.usermodel. HSSFWorkbook.
The
java.io.InputStream class is used to create file. We are creating an
excel file named "newrajesh.xls". The
org.apache.poi.hssf.usermodel. HSSFWorkbook class is used to create
an object of HSSFWorkbook, by which we will write our new rajesh.xls
file. This object allows us to modify the excel file. The
org.apache.poi.hssf.usermodel.HSSFSheet is used to create an object
of sheet .
The
org.apache.poi.hssf.usermodel.HSSFSheet is used to create a new
sheet. This class extends java.lang.Object. It is used to create a
high level worksheet.
To create new
sheet, we use HSSFSheet constructor in which we pass the name of the
sheet as an string argument. We can create any number of sheets. As
we are creating here six sheet as named new sheet, second sheet
,third sheet ,fourth sheet, and fifth sheet.
You have to follow
the following steps to execute this example:
Steps:
Download the
POI.jar from Apache Jakarta Project .
Extract it and
then copy
poi-2.5.1-final-20040804.jar,poi-contrib-2.5.1-final-20040804.jar and
poi-scratchpad-2.5.1-final-20040804.jar into
C:\apache-tomcat-5.5.23\common\lib directory .
Then download our
example copy it into C:\apache-tomcat-5.5.23\webapps\excel.
Start the web
server.
Create folder into
C drive with the name of C:\excel.
To compile and run
open Internet Explore and write
http://localhost:8080/excel/excelPoi.jsp.
After pressing
enter or on click Go. Output "Your file has been created
succesfully" will be diplay on browser
The excel file
will be generated into C:\excel folder.
The code of the
program is given below:
<%@ page import="java.io.InputStream" %>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@ page contentType="application/vnd.ms-excel" %>
<%@ page import="java.io.*" %>
<%
try {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet1 = wb.createSheet("new sheet");
HSSFSheet sheet2 = wb.createSheet("second sheet");
HSSFSheet sheet3 = wb.createSheet("third sheet");
HSSFSheet sheet4 = wb.createSheet("fourth sheet");
HSSFSheet sheet5 = wb.createSheet("third sheet");
HSSFSheet sheet6 = wb.createSheet("fifth sheet");
FileOutputStream fileOut = new FileOutputStream
("c:\excel\newrajesh.xls");
wb.write(fileOut);
fileOut.close();
out.println("Your file has been created succesfully");
} catch ( Exception ex ) {
}
%>
