how to save html form input data to excel file using java, not showing error in net beans but not showing Data is saved in exce

added jar file:- poi-3.7.jar form.jsp <%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE html><html><head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body> <form name="userform" method="post" action="excelFile.jsp"> <table> <tr><td>Enter First Name:</td><td><input type="text" name="firstName"></td></tr> <tr><td>Enter Last Name:</td><td><input type="text" name="lastName"></td></tr> <tr><td>Enter User Name:</td><td><input type="text" name="userName"></td></tr> <tr><td>Enter Address:</td><td><input type="text" name="address"></td></tr> <tr><td>Enter Email ID:</td><td><input type="text" name="email"></td></tr> <tr><td>Enter DOB:</td><td><input type="text" name="dob"></td></tr> <tr><td><input type="submit" value="Export to excel"></td></tr> </table></form> </body></html> excelFile.jjsp below the excelFile.jsp is here

java jsp corejava

8th May 2018, 8:46 PM

Susovan Das

1 Answer

<%@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 value1=request.getParameter("firstName"); String value2=request.getParameter("lastName"); String value3=request.getParameter("userName"); String value4=request.getParameter("address"); String value5=request.getParameter("email"); String value6=request.getParameter("dob"); 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("Address"); rowhead.createCell((short) 4).setCellValue("E-mail Id"); rowhead.createCell((short) 5).setCellValue("Date Of Birth"); HSSFRow row = sheet.createRow((short)1); row.createCell((short)0).setCellValue(value1); row.createCell((short)1).setCellValue(value2); row.createCell((short)2).setCellValue(value3); row.createCell((short)3).setCellValue(value4); row.createCell((short)4).setCellValue(value5); row.createCell((short)5).setCellValue(value6); FileOutputStream fileOut = new FileOutputStream("c:\\File.xls"); wb.write(fileOut); fileOut.close(); out.println("Data is saved in excel file."); }catch ( Exception ex ){ } %>

8th May 2018, 8:50 PM

Susovan Das