Jsp to Excel
In this section you will learn how to create an excel file and write data into it using jsp. For this, you have to import the package org.apache.poi.hssf.usermodel.* in order to use the classes HSSFSheet, HSSFCell, HSSFRow, HSSFWorkbook. The class HSSFRow allow us to create a row in which we can set the cells and in order to create a new cell and add the values into cells, we have used the class HSSFCell.
createSheet("sheet") : This method is used to create a HSSFSheet.
createRow((short)value) : This method is used to create a new row. We have used ((short)0) as a value for creating 0th row.
createCell((short)value) : This method is used to create a new cell. We have used ((short)0) as a value for creating 0th cell.
setCellValue(values) : This method is used to add the value into the cell. You can add value of any data type into cell by using this method.
Here is the code of excel.jsp
| <%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%> <%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%> <%@ page import="org.apache.poi.hssf.usermodel.HSSFCell"%> <%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%> <%@ page import="java.io.*" %> <%try{ HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet(" sheet"); HSSFRow row = sheet.createRow((short)0); HSSFCell cell = row.createCell((short)0); cell.setCellValue(1); row.createCell((short)1).setCellValue("Anusmita Singh"); row.createCell((short)2).setCellValue("Delhi"); row.createCell((short)3).setCellValue("[email protected]"); FileOutputStream fileOut = new FileOutputStream("c:\\data.xls"); wb.write(fileOut); fileOut.close(); }catch ( Exception ex ){ } %> |
The excel sheet is created in the C drive with the specified data:
