raghavendra
how to insert form data into excel file using jsp?
June 2, 2010 at 10:39 AM
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");
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
