You really ought to be looking outside of CF for transfers of large datasets, especially into Excel. Have you tried using SSIS (SQL Server Integration Services) for this? It's really not that difficult to do and it'll handle millions of rows easily...
-- Jeff -------- Original Message -------- > From: "funand learning" <funandlrnn...@gmail.com> > Sent: Tuesday, July 01, 2014 10:06 AM > To: "cf-talk" <cf-talk@houseoffusion.com> > Subject: Writing huge data to excel > > 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:358782 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm