Hi Robert, You can have a look at POI:
http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm Or wait patiently for ColdFusion 9 ( which uses POI I believe behind the scenes ) with the new <cfspreadsheet /> tag. Paul -----Original Message----- From: Imperial, Robert [mailto:[email protected]] Sent: Thursday, September 17, 2009 12:42 PM 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:4808 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
