Ive actually become quite fond of CF's Spreadsheet functions, though I prefer to use the script versions as I find them more flexible when dealing with large datasets, formatting content for reports and working with multiple sheets:
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec1fb12-7fd6.html You can create your workbook and then use SpreadsheetWrite() to write each worksheet to the workbook. I think youll find that having a dynamic number of sheets in the workbook will be easier using script syntax. HTH, Jon On Jul 1, 2014, at 10:03 AM, funand learning <[email protected]> wrote: > > Hi, > > I am working on exporting data to excel with multiple sheets. The sheets > are dynamic and may range from 2 to more than 5. What is the best way to > handle this? > > 1) Use cfspreadsheet or APACHE POI? Do these support dynamic creation of > sheets? I have tried with cfspreadsheet but only the last sheet is > displayed in excel > 2) Use AJAX? If yes, is there an example on how to achieve this? > > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
