Yeah I would agree with Brontojoris...I have used code written as per Ryan's post, to output in Excel and it was pretty neat.
On Mar 27, 8:40 pm, Brontojoris <[EMAIL PROTECTED]> wrote: > 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: cfaussie@googlegroups.com [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 cfaussie@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---