generate excel file

[andyc209]

I want to create an excel file based on data passed from the DB. so far I have used

set fso = createobject("scripting.filesystemobject")
act.write(blah blah) etc

to generate csv file on the server that the user can then open and print. However I want to create formated excel files, I have seen people say use

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

but I do not want them to have the file open for them, I just want the page to create the file on the server ready for them to open.

can anyone help

 

[vicvirk]

If you are not doing a lot of formatting, you can save the file as a CSV and provide a link to download it.

Excel will open CSV files and display the information in a tabular format.



--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

 

[ggriffit]

check out

http://www.greggriffiths.org/webdev/both/excel/

which covers this.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/