coldfusionapache-poiindexoutofboundsexceptioncfspreadsheet

Data row limits on cfspreadsheet

I am loading about 20,000 rows into a <cfspreadsheet>. It throws an error:

enter image description here

When I limit the number of rows to 15,000, I don't get an error.

Is there a hard limit on the number of rows <cfspreadsheet> supports?

Solution

  • This sounds similiar to the issue I had here: How do I fix SpreadSheetAddRows function crashing when adding a large query?. If you have CF10 then you might be in luck 'cause that should be fixed now (as of Update 10 at least).