Re: Export to Excel spread Sheet

[Dahnke, Eric]

Yes. Post to the exact same page but set header values like:

 

Content-Type: application/vnd.ms-excel; name='excel'
Content-Disposition: attachment; filename=filename.xls

With this in the http headers your browser will automatically open Excel. And the final trick is that Excel can read html tables. (Hopefully there is nothing else on your page but the html table)

 

HTH

 

-----Original Message-----
From: tejas patel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:49 PM
To: [EMAIL PROTECTED]
Subject: Export to Excel spread Sheet

Hi all,

any one knows how to transfer data to excel spread sheet. Basically, My servlet connect to database and display all data in Table in HTML. later on I want to transfer all data to excel spread sheet. any example ...

thanks

tejas

---

Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®