Question
Create Excel spreadsheet
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
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
