Rick, >I'm using the POI library to produce excel files.. specifically the >library that is included with CF8. I don't think I installed any >additional class files. > >Anyway, when I produce excel files larger than 65536 rows, they get >cut off, and when I open the file in Excel I get "File Error: Data >may have been lost" > >But Excel seems to open delimited text files of greater than 65536 >rows with no problem. > >Can excel not handle actual worksheets with > 65536 rows? Or is the >Java POI interface somehow limiting the worksheets it creates to that >number of rows?
You'll need to split the data into multiple Worksheets. Excel has a row limit of 65536 for a native XLS file for each Worksheet: http://answers.google.com/answers/threadview?id=6207 -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296531 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
