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 obj
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"
http://ca
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 exte
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 S
> 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).
http://www.bennadel.com/blog/624-ColdFusion-POIUtility-cfc-Updates-And-Bu
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:-)
&g
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: 040
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 D
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:[E
