Hi friend,

Code to data from Jsp to excel sheet.

"abc.jsp"

<%@ page language="java" import="java.io.*" %>
<form method="post" action="success.jsp">
<p><font color="#800000" size="5">Enter XLS file name:</font>
<input type="text" name="username" size="20"></p>
<input type="password" name="password" size="20"></p>
<input type="text" name="first_name" size="20"></p>
<input type="text" name="last_name" size="20"></p>
<p><input type="submit" value="Create"
onclick="document.location='success.jsp';"/>
</p>
</form>


<%@ 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.*" %>
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
String first_name=request.getParameter("first_name");
String last_name=request.getParameter("last_name");
%>

"success.jsp"
<%try{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("new sheet");
HSSFRow row = sheet.createRow((short)0);
HSSFCell cell = row.createCell((short)0);
cell.setCellValue(1);
row.createCell((short)1).setCellValue(username);
row.createCell((short)2).setCellValue(password);
row.createCell((short)3).setCellValue(first_name);
row.createCell((short)3).setCellValue(last_name);
FileOutputStream fileOut = new FileOutputStream("c:\\"new".xls");
wb.write(fileOut);
fileOut.close();
}catch ( Exception ex ){
}
%>

For more information on excel sheet Using JSP visit to :

http://www.roseindia.net/jsp/poi/index.shtml

Thanks