I second Ryan's suggestion. We have done it for our site, and there is no need for Java or other server extensions, just write out a properly formated Excel 2003+ XML file. As a bonus you to multiple worksheets, you also get formatting, cell sizing, text wrapping, etc.
On Mar 27, 4:48 pm, Ryan Sabir <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
