Skip to main content
Inspiring
May 26, 2006
Question

Create Excel spreadsheet

  • May 26, 2006
  • 3 replies
  • 286 views
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



This topic is closed to new replies. Start a new post to keep the conversation going.

3 replies

Inspiring
May 30, 2006
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



Inspiring
May 26, 2006
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




Inspiring
May 26, 2006
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