Support Forums: Message List - How to output JSP page to Excel ?

Export JSP to Excel

Thu, 13 Sep 2012 14:35:36 -0400

Ignore the link in the previous post, here is the correct link:

...

Export JSP to Excel

Thu, 13 Sep 2012 14:26:28 -0400

Its fairly simple and can be done with minimum changes to your existing JSP. Take a look at this example on quicklyjava.com:

...

export data to excel using jsp

Fri, 14 Aug 2009 11:01:46 -0400

In my application data is getting export to excel sheet but it is not in proper way as generally excel sheet looks. I mean if i want particular string in particular cell,how do i do that? Please reply urgent!!...

Excel in jsp * this works

Thu, 02 Aug 2007 04:47:20 -0400

I spend a day to find out this solution...

Is it working?

Tue, 04 Oct 2005 11:43:32 -0400

I've a similar requirement and would like to know whether you were able to do it.,

Please let me know whether you're able to make it working..

Thanks

using hidden fields

Sun, 04 Sep 2005 23:07:59 -0400

Hi,
For displayTag, must have data as list ? My output is multiple tables which cannot be created just by list. So, is it true that I cannot use displayTag ?

What I'm doing now is to have hidden fields created on the JSP page which displays the...

How to output JSP page to Excel ?

Fri, 02 Sep 2005 10:10:27 -0400

If you want a quick and easy way to output data to excel you can use the displaytag library (www.displaytag.org). Other than that you can use POI, Coccoon or an API called JXL.

M

Try with this

Fri, 02 Sep 2005 06:19:46 -0400

Hi,

Hope, it will work for you..

copy the contents in a string...

How to output JSP page to Excel ?

Fri, 02 Sep 2005 03:41:59 -0400

Hi all.

Try with this sample code:

[BEGIN FILE: excel.jsp]
<%
response.reset();
response.setHeader("Content-type","application/xls");
response.setHeader("Content-disposition","inline;...

sample code, pls (Urgent)

Fri, 02 Sep 2005 02:02:25 -0400

Trying to digest what is in the apache (POI) website, but lost.

can someone kindly provide sample code on how to use POI to export the result on JSP to Excel ? and also what to download for POI ?

Thanks...

to open in jsp first then click button to open in Excel

Fri, 02 Sep 2005 01:58:52 -0400

What I need is to first display the result in JSP and to display in Excel when button "Export to Excel" is clicked ? So I believe the following will display the result as Excel without displaying in JSP, right...

How to output JSP page to Excel ?

Fri, 02 Sep 2005 00:30:10 -0400

One way would be to present your output in csv format and have the browser open it in excel.

From memory the code looked like...

POI can help u out

Fri, 02 Sep 2005 00:05:50 -0400

i think you can use the apache POI, here is the link http://jakarta.apache.org/poi/index.html

How to output JSP page to Excel ?

Thu, 01 Sep 2005 21:02:03 -0400

Result is displayed in the JSP and there is a button on the JSP which I want to output the result to Excel file when clicked. How to do that ?

Thanks...