QuestionAsk Questions?
hari
View Answers
December 21, 2008 at 10:39 PM
Hi friend,
Code to help in solving the problem :
<html>
<head>
</head>
<body>
<br><br><br><br>
<form name="searchForm" method="post" action="excelData.jsp">
<table align="center" bgcolor="LIGHTBLUE">
<tr>
<td colspan=3 align="center"><b><span style="font-size:20px;">Create a Excel file</span></b></td>
</tr>
<tr>
<td colspan=3> </td>
</tr>
<tr>
<td><b>Search</b></td>
<td><input type="text" name="empid" value=""></td>
<td><input type="submit" name="Submit" value="Search"></td>
</tr>
<tr>
<td colspan=3> </td>
</tr>
</table>
</form>
</body>
</html>
"excelData.jsp"
<%@ 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"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%!
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;;
String dbName = "user_register";
String driver = "com.mysql.jdbc.Driver";
String username = "root";
String userPassword = "root";
%>
<br><br>
<%
java.util.Date date = new java.util.Date();
String filename = "c:\\excel\\f"+date.getTime() +".xls" ;
String empid="";
if(request.getParameter("empid")!=null)
{
empid= request.getParameter("empid").toString();
}
try{
HSSFWorkbook hwb = new HSSFWorkbook();
HSSFSheet sheet = hwb.createSheet("new sheet");
int index=1;
HSSFRow row = sheet.createRow((short)index);
row.createCell((short) 0).setCellValue(empid);
row.createCell((short) 1).setCellValue(date);
index++;
FileOutputStream fileOut = new FileOutputStream(filename);
hwb.write(fileOut);
fileOut.close();
out.println("<b>Your excel file has been generated</b>");
} catch ( Exception ex ) {
}
%>
Thanks
Code to help in solving the problem :
<html>
<head>
</head>
<body>
<br><br><br><br>
<form name="searchForm" method="post" action="excelData.jsp">
<table align="center" bgcolor="LIGHTBLUE">
<tr>
<td colspan=3 align="center"><b><span style="font-size:20px;">Create a Excel file</span></b></td>
</tr>
<tr>
<td colspan=3> </td>
</tr>
<tr>
<td><b>Search</b></td>
<td><input type="text" name="empid" value=""></td>
<td><input type="submit" name="Submit" value="Search"></td>
</tr>
<tr>
<td colspan=3> </td>
</tr>
</table>
</form>
</body>
</html>
"excelData.jsp"
<%@ 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"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%!
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;;
String dbName = "user_register";
String driver = "com.mysql.jdbc.Driver";
String username = "root";
String userPassword = "root";
%>
<br><br>
<%
java.util.Date date = new java.util.Date();
String filename = "c:\\excel\\f"+date.getTime() +".xls" ;
String empid="";
if(request.getParameter("empid")!=null)
{
empid= request.getParameter("empid").toString();
}
try{
HSSFWorkbook hwb = new HSSFWorkbook();
HSSFSheet sheet = hwb.createSheet("new sheet");
int index=1;
HSSFRow row = sheet.createRow((short)index);
row.createCell((short) 0).setCellValue(empid);
row.createCell((short) 1).setCellValue(date);
index++;
FileOutputStream fileOut = new FileOutputStream(filename);
hwb.write(fileOut);
fileOut.close();
out.println("<b>Your excel file has been generated</b>");
} catch ( Exception ex ) {
}
%>
Thanks
Related Pages:
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.
Tutorial Topics
