CF9 - Creating spreadsheets with cfspreadsheet using spreadsheetAddRows() is slow

[JonC]

There is slowness when creating spreadsheets with <cfspreadsheet> while using the function spreadsheetAddRows(). According to reports for 100 rows approximate time is 1 second or more, 250 rows 20+ seconds. This is a known bug in ColdFusion 9, and there is currently no fix provided by Adobe for this problem. The known work around for this issue is to use Ben Nadel's POI Utility. Using the POI Utility the same 250 rows created takes less than one second.

See Adobe Bug Report for slowness using spreadsheetAddRows().

[JonC]

Adobe fixed this function in the 9.0.1 update, to fix they suggested testing the code on a 9.0.1 server before hand.

Secondly, instead of using the POI utility which is not designed for speed but overall flexibility, the tag <cfspreadsheet> can be used in replacement of the spreadsheetAddRows() function, customers reporting 1000% increase in speed using the tag vs the function.