need help for jsp/excel? 1

[lodhi]

Hi All,

i have devloped a web site. now i want when user clicks
a link i want to run excel that should automatically load
a table from SQL Server database. please guide me how can
i do this. like i have to write some macro for reading Database or any thing else.

thanks,

omar lodhi

 

[Nescio]

The primary trick to outputing to an excel file is changing the the contentType tag to <%@page contentType=&quot;text/html&quot;%> and using tabs between cells in your output. There is a great example to be found here in this downloadable book:

http://pdf.coreservlets.com/

Enjoy

Nescio