jsp excel code

Hi
how to insert form data into excel file using jsp?

View Answers

June 2, 2010 at 10:39 AM

Hi Friend,

Try the following code:

1)register.jsp:

<html>
<body>
<center><h3>Registration Form</h3></center>
<form method="POST" action="insertIntoExcel.jsp">
<center>
<table>
<tr><td>First Name:</td><td><input type="text" name="firstname" size="20"></td></tr>
<tr><td>Last Name:</td><td><input type="text" name="lastname" size="20"></td></tr>
<tr><td>User Name:</td><td><input type="text" name="username" size="20"></td></tr>
<tr><td>Password:</td><td><input type="text" name="password" size="20"></td></tr>
<tr><td>Address </td><td><input type="text" name="address" size="20"></td></tr>
<tr><td>Contact No </td><td><input type="text" name="contact" size="20"></td></tr>
<tr><td>Email: </td><td><input type="text" name="email" size="20"></td></tr>
<tr><td>City: </td><td><input type="text" name="city" size="20"></td></tr>
<tr><td>State: </td><td><input type="text" name="state" size="20"></td></tr>
<tr><td>Country: </td><td> <input type="text" name="country" size="20"></td></tr>
<tr><td><input type="submit" value="Submit" name="B1"></td><td><input type="reset" value="Reset" name="B2"></td></tr>
</table>
</center>
</form>
</body>
</html>

2)insertIntoExcel.jsp:

<%@page import=" java.io.*"%>
<%@page import=" org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import=" org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@page import=" org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import=" org.apache.poi.hssf.usermodel.HSSFCell"%>
<%
String fname= request.getParameter("firstname");
String lname= request.getParameter("lastname");
String uname= request.getParameter("username");
String pass= request.getParameter("password");
String address= request.getParameter("address");
String contact=request.getParameter("contact");
String email=request.getParameter("email");
String city=request.getParameter("city");
String state=request.getParameter("state");
String country=request.getParameter("country");
try{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Excel Sheet");
HSSFRow rowhead = sheet.createRow((short)0);
rowhead.createCell((short) 0).setCellValue("First Name");
rowhead.createCell((short) 1).setCellValue("Last Name");
rowhead.createCell((short) 2).setCellValue("User Name");
rowhead.createCell((short) 3).setCellValue("Password");
rowhead.createCell((short) 4).setCellValue("Address");
rowhead.createCell((short) 5).setCellValue("Contact No");
rowhead.createCell((short) 6).setCellValue("Email");
rowhead.createCell((short) 7).setCellValue("City");
rowhead.createCell((short) 8).setCellValue("State");
rowhead.createCell((short) 9).setCellValue("Country");

HSSFRow row = sheet.createRow((short)2);
row.createCell((short)0).setCellValue(fname);
row.createCell((short)1).setCellValue(lname);
row.createCell((short)2).setCellValue(uname);
row.createCell((short)3).setCellValue(pass);
row.createCell((short)4).setCellValue(address);
row.createCell((short) 5).setCellValue(contact);
row.createCell((short) 6).setCellValue(email);
row.createCell((short) 7).setCellValue(city);
row.createCell((short) 8).setCellValue(state);
row.createCell((short) 9).setCellValue(country);

FileOutputStream fileOut = new FileOutputStream("c:\\excelFile.xls");
wb.write(fileOut);
fileOut.close();
out.println("Data is saved in excel file.");
}
catch(Exception e){}
%>

Thanks

October 13, 2011 at 11:09 PM

hi..i tried the above code.but i m facing an error stated below.pls provide a solution.

An error occurred at line: 18 in the jsp file: /xcel.jsp HSSFWorkbook cannot be resolved to a type 15: String state=request.getParameter("state"); 16: String country=request.getParameter("country"); 17: try{ 18: HSSFWorkbook wb = new HSSFWorkbook(); 19: HSSFSheet sheet = wb.createSheet("Excel Sheet"); 20: HSSFRow rowhead = sheet.createRow((short)0); 21: rowhead.createCell((short) 0).setCellValue("First Name");

October 13, 2011 at 11:10 PM

hi..i tried the above code.but i m facing an error stated below.pls provide a solution.

An error occurred at line: 18 in the jsp file: /xcel.jsp HSSFWorkbook cannot be resolved to a type 15: String state=request.getParameter("state");

16: String country=request.getParameter("country");

17: try{

18: HSSFWorkbook wb = new HSSFWorkbook();

19: HSSFSheet sheet = wb.createSheet("Excel Sheet");

20: HSSFRow rowhead = sheet.createRow((short)0);

21: rowhead.createCell((short) 0).setCellValue("First Name");