I'm using CR4J to generate reports and automatically export them to excel format, but when I have more than the MS 2007 65536 allotted rows in a report the excel file is not generated. The report will not always have that many rows though. So is there a way to have my reports dynamically split up into multiple spreadsheets when it hits that limit? Without affecting the way that it looks in a pdf or in the viewer?
There is no functionality available that will automatically split the report into multiple sheets or files. You would need to figure out where you needed to split it and export the report to multiple files. If you wanted it as multiple sheets, you would have to look at the Excel sdk from microsoft on how to combine multiple files into one.