You could use POI to add a new sheet to an existing doc. You can use
JavaLoader to suck in the latest version of POI so you don't have to
overwrite the one that ships with CF 8. POI has always worked great for
me with standard xls files. I've only had trouble when playing with the
new OOXML stuff in Office 2007 and higher. It seems to work fine for
others though. With POI, you can open an existing xls file or pass one
in from memory and make it an HSSF workbook object. You can then use the
createSheet() function and pass it a sheet name, etc.
On 10/11/11 2:13 PM, Matthew Nicholson wrote:
Jason, Dawn, thank you both so much for the suggestions!
I am stuck on CF8 although I'm trying to avoid having to re-write the
HTML page to utilize the POI API (or CFXL that Jason provided).
What flexibility do we have with appending to an already established
document (with a new sheet?)
/Matthew R. Nicholson/
/SolTech, Inc./
/_www.soltech.net <http://www.soltech.net/>_/
/(p) 404.601.6000, Ext 233/
/(c) 770.833.5326/
*Yes. We can get you there.*
*From:*[email protected] [mailto:[email protected]] *On Behalf Of *Jason
Delmore
*Sent:* Tuesday, October 11, 2011 4:03 PM
*To:* [email protected]
*Subject:* Re: [ACFUG Discuss] PDFs / Excel Shenanigans
Jason - If you're on CF8, I posted CFXL on Riaforge at
http://cfxl.riaforge.org/. It also uses POI, and you can similarly
create multiple sheets.
Dawn - ColdFusion 9 uses the Apache POI project to create Excel
spreadsheets. You can access all of the bits natively to create
multiple sheets. You can find tons of info about POI here:
http://poi.apache.org/
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink <http://www.fusionlink.com>
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
