Thank you. I am not using SpreadSheetWrite function to write to a file. I am storing all the sheets in a variable and using cfheader and cfcontent to prompt the user to save or download. Do you think this is a preferred option?
On Tue, Jul 1, 2014 at 2:17 PM, Jon Clausen <[email protected]> wrote: > > Iâve 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 youâll 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:358784 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
