Generate it as XML..
1. Manually create the spreadsheet in Excel, with the multiple worksheets. 2. Save it as XML 3. Examine the XML in a text editor and use your mad CF skillz to recreate the content dynamically 4. Profit! -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, 27 March 2008 4:40 PM To: cfaussie Subject: [cfaussie] Creating Excel files with multiple worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
