Forums Register Login

Export to excel

+Pie Number of slices to send: Send
Hi
source code required to .. "export to excel "
prabhu
+Pie Number of slices to send: Send
Look for the apache POI project.
D.
+Pie Number of slices to send: Send
I am new to Java, so my solution might not be very sofisticated. But it works.

//Here is the code I used:
//This is an HTML or JSP page, that is used to pass the query to a seocnd page:

<html>
<head><title>Pass SQL Query </title></head>
<body>

<%
String query = "Select * from Customers";
%>

<p><font size="+1">[<a href="excel.jsp?SQL=<%=query%>">Export results to Excel</a>]</font>

</body>
</html>

-------------------------------------------------------
/*Second JSP Page will look something like this:
*Notice that I used a Bean here "JDBC_Wrapper" to open the database *connection and execute the query.
*/

<%@ page import = "java.sql.*, somefolder.JDBC_Wrapper" %>
<jsp:useBean id="myCBean" class="somefolder.JDBC_Wrapper" scope="session"/>

<HTML>
<HEAD>
<TITLE>Export Data to Excel</TITLE>
</HEAD>
<body>

<%
String SQL = request.getParameter("SQL");
myCBean.DbInit();
ResultSet rs = myCBean.queryTable(SQL);

//Display results in excel
response.setContentType("application/vnd.ms-excel");
response.setHeader("content-disposition","attachment;filename=report.xls");
%>

<table border="1" >
<thead>
<tr>
<th>Column1 Name</th>
<th>Column2 Name </th>
</tr>
</thead>

<tbody>

<%while (rs.next()){ %>
<tr>
<td><%= rs.getString(1) %></td>
<td><%= rs.getString(2) %></td>
</tr>
<% } %>

</tbody>
</table>

<%

myCBean.DbClose();
%>

</body>
</html>
+Pie Number of slices to send: Send
use csv!!! that is comma separator value.

String x="bla, bla";

when you write it in csv the result will be "bla bla" in 2 separtes boxes.

best of luck
You’ll find me in my office. I’ll probably be drinking. And reading this tiny ad.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 3204 times.
Similar Threads
how to export data to Excel
JasperReports -- excel issue
How to Export Data from JSP to Excel
Export functionality
How to export data in excel
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 03:38:03.