Hi Bob, Check out Ben Nadel's POI utility for reading and writing to excel files. http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm
I've used it to read in files, not tried writing them with it, but it's all good stuff, and looks like it will do what you need. Will -----Original Message----- From: Imperial, Robert [mailto:[email protected]] Sent: 17 September 2009 17:42 To: cf-newbie Subject: xls in Coldfusion Hi folks, I am venturing into new territory in working with creating xls files with multiple sheets. I've worked with creating basic spreadsheets in Coldfusion using cfcontent and single queries, fairly easy and straightforward. I need some direction as to how to go about creating an xls file with multiple sheets in it. I have data to grab from 22 different tables and ideally each sheet within the excel file would be based on these individual query result sets from these tables. Clueless as to where to begin to pull this off or if it can even be done as I've mentioned, so any and all help/guidance/direction would be greatly appreciated. I work alone here unfortunately so this list and a couple of others are my only resource to pull from aside from my collection of books ;) TIA Bob Imperial Department of Medicine 043B Macnider Hall, CB 7005 UNC Chapel Hill, NC 27599 Phone: (919) 843-6151 Fax: (919) 966-5775 "If you want truly to understand something, try to change it." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4809 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
