Hey gang - Running CF 9.0.1 on Linux, also running FusionReactor for monitoring. Let's get that out of the way :)
I have an old export utility that writes out to Excel (using Ben Nadel's POIutil) and I'm exploring migrating that over to using CF9's cfspreadsheet functionality. Thanks to a bit of googling I've found how to get CF to export an .xlsx file (to allow for >65k rows), which is my goal along with (hopefully) a bump in performance. I've tried doing this two ways - dumping a query recordset straight into a <cfspreadsheet> tag, and using the related functions (SpreadsheetNew(), SpreadsheetAddRows(), etc) to create/format/populate a spreadsheet object, and then SpreadsheetWrite() to write out the file. I'd prefer to stick with the SS*() functions as I'm able to do a bit of customization of the header row. (If there's a way to do that with <cfspreadsheet>, I have yet to find it. The online docs from Adobe are pitiful.) After tinkering with various options and such, I've found that I'm able to get the SS*() functions to do what I want - almost. There's two chokepoints involved - one is the SpreadsheetAddRows() function, which by itself runs fairly long - longer than POIutil and <cfspreadsheet> would run to completion - and the other is the SpreadsheetWrite() function. It appears from testing (and monitoring the target file/directory via FTP) that it writes the file fine, and doesn't take all that long to complete that task - but the script itself runs for quite a while longer after that point before moving onto the next bit of code (just a 'file written' message output) - assuming it gets that far. I've seen the script simply... stop working. No error, no nothing, it just stops. (And just now, trying a larger recordset, I had my script quit out on me during the SpreadsheetAddRows() portion of the process. Didn't even get to the SpreadsheetWrite() part.) If there's some tricks to getting these functions to run better, I'd love to hear'em. Thanks in advance - --Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352773 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
