|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
June 16th, 2004, 10:56 AM
|
|||
|
|||
|
Dynamic excel report, multiple work sheets
Currently I have excel document being generated using the cfheader and cfcontent code;
<CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=report.xls"> <CFCONTENT TYPE="application/msexcel"> With the information be inputted using a query loop inside tables, my client would like each category that’s outputted to show up on a different worksheet and each worksheet being named that category name, How would I go about doing this. Any suggestions would be greatly appreciated. Thank you
|
|
#2
June 16th, 2004, 11:36 AM
|
|||
|
|||
|
Simply using CFHEADER and CFCONTENT won't allow you to populate multiple worksheets in an Excel file. As far as I know, you'll either need to use a COM object call to create the Excel file, or create the appropriate XML markup that conforms to the Excel XML schema/DTD.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Dynamic excel report, multiple work sheets |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
