Creating xls files on users pc

[Luis]

The MSDN KB article 189198
(http://support.microsoft.com/default.aspx?scid=kb;en-
us;189198) describes how to create a spreadsheet with info
from a database. Is there a way to create the spreadsheet
on the users computer instead of on the web server? I want
to prevent a whole lot of xls files from being created and
stored on the server.

 

[CJM]

Create the XLS as described in the article, then stream it to the client.

http://www.darkfalz.com/Scripts_Details.aspx?pstID=1098

Chris

 

[Tom Kaminski [MVP]]

You can actually skipped the whole ADODB.Stream part as in this case the OP
doesn't want to create any files on the server. Just output an HTML table
and change the ContentType to Excel:

http://support.microsoft.com/?kbid=301044

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserver2003/community/centers/iis/
http://mvp.support.microsoft.com/
http://www.iisfaq.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://www.tryiis.com