hi,
i have a problem when i open any excel file via a browser
i'm unable to view the results in excel format;so i gave mime-mapping as follows
 <mime-mapping>
  <extension>xls</extension>
  <mime-type>application/excel</mime-type>
 </mime-mapping>
also i included this in the jsp
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition","inline; filename=" +"C
"+"filename.xls");

after this its opening in excel format in the browser with no close button and no data
please help me asap

How are you opening the excel file?

Are you providing the link in your jsp page for excel file stored in server file system? or

You are trying to show the output data of a JSP page in excel file format ?


Anil Saidneni

i solved the problem

please provide details on how to solve it

please provide details on how to solve it

 

Please see the details posted by me on this thread for an example of how to add excel functionality to your JSP code

I was speaking of

 

>>how to after this its opening in excel format in the browser with no close button and no data
please help me asap<<

how did you solve this problem the no close button ??

Can you share with me how to output data of a JSP page in excel file format ? Thanks.

Just insert into your JSP the following line of code.


Life long and prosper
Tobias

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

 

http://www.quicklyjava.com/export-web-page-to-word/

 

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

 

http://www.quicklyjava.com/export-web-page-to-excel/