<div>
set the contect type as &quot;text/vnd.msexcel&quot; 
</div>


set the contect type as "text/vnd.msexcel"

<div>
typo there<br />
<br />
response.setContentType(&quot;a<wbr />pplication<wbr />/vnd.ms-ex<wbr />cel&quot;)
</div>


typo there

response.setContentType("application/vnd.ms-excel")

<div>
might not be of much help but just in case ...<br />
<br />
<a href="http://www.intrinsyc.com/support/j-integra/doc/servlet_com/excel_example_servlet.html" rel="ugc">http://www.intrinsyc.com/support/j-integra/doc/servlet_com/excel_example_servlet.html</a>
</div>


might not be of much help but just in case ...

http://www.intrinsyc.com/support/j-integra/doc/servlet_com/excel_example_servlet.html [http://www.intrinsyc.com/support/j-integra/doc/servlet_com/excel_example_servlet.html]

<div>
a commerical product<br />
<a href="http://www.brothersoft.com/Software_Developer_Java_ExcelEverywhere_for_JavaJSP_20009.html" rel="ugc">http://www.brothersoft.com/Software_Developer_Java_ExcelEverywhere_for_JavaJSP_20009.html</a>
</div>


a commerical product
http://www.brothersoft.com/Software_Developer_Java_ExcelEverywhere_for_JavaJSP_20009.html [http://www.brothersoft.com/Software_Developer_Java_ExcelEverywhere_for_JavaJSP_20009.html]

<div>
I actually have exported data to excel already. just need to split it into different workbooks within the same excel session.
</div>


I actually have exported data to excel already. just need to split it into different workbooks within the same excel session.

<div>
Thanx.<br />
<br />
I'm glad it's worked. &nbsp;Could you confirm which versions of Excel this works with please? &nbsp;(I'm a Linux user so it's a bit difficult to check ;-))
</div>


Thanx.

I'm glad it's worked.  Could you confirm which versions of Excel this works with please?  (I'm a Linux user so it's a bit difficult to check ;-))

<div>
<div class="content wysiwyg-content">
Hey,<br />
<br />
I retrieve data from a database, put the information in a table(html) and allow the user of the application to view it in excel if he/she so chooses. I would like to put different tables into different workbooks inside excel. <br />
<br />
Anyone have a suggestion?<br />
<br />
Thanks,<br />
<br />
Weber
</div>
</div>


Hey,

I retrieve data from a database, put the information in a table(html) and allow the user of the application to view it in excel if he/she so chooses. I would like to put different tables into different workbooks inside excel. 

Anyone have a suggestion?

Thanks,

Weber

Exporting to an Excel Database

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.