aspose file tools*
The moose likes JSP and the fly likes How to Export web page(jsp page) to excel using jsp or servlets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "How to Export web page(jsp page) to excel using jsp or servlets" Watch "How to Export web page(jsp page) to excel using jsp or servlets" New topic
Author

How to Export web page(jsp page) to excel using jsp or servlets

lisy jessica
Ranch Hand

Joined: Oct 27, 2010
Posts: 47
Hi

I am trying to export web page(jsp page ) to excel using jsp or servlets. I am retrieving records from database and displaying in the jsp page, In this page I have a save as excel button, when I click this button I need these displayed records to excel file. I tried with vbscript and javascript but am getting some errors. Please can anyone tell me how to do this using java or jsp or servlets??

Thanks in advance,
Lissy.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61766
    
  67

I would write a servlet that emits a format that Excel understand. The link can hit that servlet.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
rajiv jackz
Greenhorn

Joined: Jul 12, 2010
Posts: 29
HI
you can go head with display tag

/http://www.displaytag.org/1.2/

this link might be useful. export to excel
xsunil kumar
Ranch Hand

Joined: Dec 14, 2009
Posts: 133
Bear, you are displaying the result in JSP page. It means that you are already records available in request/ session. Now on click on save button why not you call one servlet that servlet will do writing in excel file. After that you can give link to user to download that excel file.

Regards,
Sunil
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61766
    
  67

xsunil kumar wrote:Bear, you are displaying the result in JSP page. It means that you are already records available in request/ session.

No. The request is long gone by the time the page is displayed in the browser, and no data is automatically stored in the session.

The best solution is to have a servlet that reads the same data and formats it, not as HTML, but as a format that Excel understands.

Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42930
    
  68
Bear Bibeault wrote:The best solution is to have a servlet that reads the same data and formats it, not as HTML, but as a format that Excel understands.

I'd say that's debatable; storing the data in the session can work well. That's what the DisplayTag library suggested previously does, which is indeed worth a look if the data is both to be displayed as HTML and downloaded as XLS.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61766
    
  67

I did not mean to not store in the session -- just that it won't be there automatically. And trying to extract the data from the HTML page after it has been rendered is like trying to get a steak out of hamburger.

Caching the data in the session may be a viable path depending upon the expected usage patterns of the application
lisy jessica
Ranch Hand

Joined: Oct 27, 2010
Posts: 47
I am trying to do this using javascript, but still its not working, here is my code

masterlist_fetch.jsp



This gives me an error in the webpage when i click save as excel button, the error is detailsTable is undefined, Please can anyone help me, I am stuck here.

Thanks in advance.
Lissy.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42930
    
  68
Apparently you think that because you have an element with name "detailsTable" on your page (two elements, actually, which is a bad idea), that element would be defined as a JavaScript variable. Not so. Read up on the JavaScript methods getElementsByName and getElementById to learn about how to structure your HTML pages so that what you're trying to do becomes possible.
lisy jessica
Ranch Hand

Joined: Oct 27, 2010
Posts: 47
Thanks for the reply, Will try this.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to Export web page(jsp page) to excel using jsp or servlets