Download of data into excel spreadsheet 1

[SonJ]

Hi,

I have some data stored in an sql server 2000 database, and I need to be able to download the information into an Excel spreadsheet.

If anyone has any pointers, hints, references as to how I can do this, then your help would be much appreciated.

Thanks in advance.

 

[GabeC]

Set the return type to Excel

Response.ContentType = "application/vnd.ms-excel"

You then just print out a HTML table

<Table>
<TR>
<TD>Data1</TD>
<TD>Data2</TD>
...
</TR>
</TABLE>

Hope this helps,

Gabe

 

[SonJ]

Thanks for that, it worked a treat!

Just out of curiosity, do you know how I can create 2 spreadsheets in the same file from the same asp page, and name them each differently eg Details1, Details2 in the file of Details.xls?

Again, any hints, tips or references would be much appreciated.

Thanks in advance.

 

[GabeC]

Sorry, I have never had that need. My guess would be to create an Excel file and then deliver that to the user instead of using HTML. That doesn't mean it can't be done though.

Thanks,

Gabe