Home Jsp Poi How to Create New Excel Sheet Using JSP
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

How to Create New Excel Sheet Using JSP

Advertisement
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.

How to create new excel sheet using jsp

     

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:

  1. Download the POI.jar from   Apache Jakarta Project .
  2. 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 .
  3. Then download our example copy it into C:\apache-tomcat-5.5.23\webapps\excel.
  4. Start the web server. 
  5. Create folder into C drive with the name of C:\excel.  
  6. To compile and run open Internet Explore and write http://localhost:8080/excel/excelPoi.jsp
  7. After pressing enter or on click Go. Output "Your file has been created succesfully" will be diplay on browser 
  8. 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 ) {
  
  } 
%>

The output of the program is given below:

Download this example.

Advertisement

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: May 19, 2007

Ask Questions?    Discuss: How to Create New Excel Sheet Using JSP   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
srivanibummadri
January 7, 2012
excell sheet

excell sheet
varun kumar
March 24, 2014
struts 1.3

hi i m doing project where i need to capture some parameter from the user from jsp page . so i want to capture it in excel file how do i go about it. i want to to add a button by clicking on it it should disply a spredsheet where user can input the data. plz help me out
DMCA.com