http://wikipedlla.com/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
CF8 is not an option on this project yet.
On Mar 27, 3:52 pm, Andrew Scott [EMAIL PROTECTED] wrote:
I suppose you don't have the luxury of running it under Coldfusion 8:-)
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.www.aegeon.com.au
Phone: +613 9015 8628
Mobile: 0404 998
March 2008 5:10 PM
To: cfaussie
Subject: [cfaussie] Re: Creating Excel files with multiple worksheets
CF8 is not an option on this project yet.
On Mar 27, 3:52 pm, Andrew Scott [EMAIL PROTECTED] wrote:
I suppose you don't have the luxury of running it under Coldfusion 8:-)
Andrew Scott
Senior
http://poi.apache.org/hssf/index.html
Ben Nadel has written a nice CFC wrapper for some POI functionality. It
has methods to create sheets and write excel files, though I've only
used it for reading (which works well).
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
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
Darren, besides the options mentioned so far, I'll note that I did a blog
entry a couple months ago where I tried to gather in one place all the
various ways, with links to resources with still more details:
How can I process Excel files in CFML? Let me count the ways
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
I suppose you don't have the luxury of running it under Coldfusion 8:-)
Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613 9015 8628
Mobile: 0404 998 273
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of