Create Excel spreadsheet

[Newsgroup_User]

Hi,
I need to generate an Excel spreadsheet that simply contains column headers.
My code currently has a comman separated list of all the headers I want to
include in the spreadsheet.
That list is then split into an array and each array element is wrapped in
<th> tags.
Is my next move as simple as saving the completed "file" as filename.xls
using the FSO [1] - or is this going to get more complex than that?

I can't simply change the content-type to force the user to download the
spreadsheet (as I have done on previous projects) - this system uses
functions to build the spreadsheet, and one function is used to actually
create the physical file.

I haven't tested the [1] method, I just thought of it while typing this
message!

Ideas or pointers would be appreciated!
Cheers,
Rob
http://robgt.com/ [Tutorials and Extensions]
Firebox stuff: http://robgt.com/firebox
Skype stuff: http://robgt.com/skype
Dell stuff: http://robgt.com/dell
SatNav stuff: http://robgt.com/satnav

[Newsgroup_User]

Oops, forgot to mention, this is being written in ASP VBscript.
Cheers,
Rob
http://robgt.com/ [Tutorials and Extensions]
Firebox stuff: http://robgt.com/firebox
Skype stuff: http://robgt.com/skype
Dell stuff: http://robgt.com/dell
SatNav stuff: http://robgt.com/satnav

[Newsgroup_User]

Yup Rob. Just use the FSO to save the save the file to disk.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Newsgroup_User]

Thanks Jules!

Cheers,
Rob
http://robgt.com/ [Tutorials and Extensions]
Firebox stuff: http://robgt.com/firebox
Skype stuff: http://robgt.com/skype
Dell stuff: http://robgt.com/dell
SatNav stuff: http://robgt.com/satnav