As we know the max row number allowed in one excel worksheet is 65535.
I want to use UltraGridExcelExporter to export a grid which is with more than 65535 rows to excel but I find that you can only set the StartRow and StartColumn in the Export method. What I want is that you could also set some parameters such as EndRow so I can splite the grid into multi sheets.
Is there any easy solution to this problem?
Well... I don't think the WinGridExcelExporter gives you the object to target Excel 2007 at present.
I don't know of any way to do this right now. What you would probably have to do is break up your data into multiple grids and export each one to a separate worksheet in the same report. You could probably use a single grid and just change it's data source repeatedly and export it in a loop.
You should probably submit this to Infragistics as a feature request (or 2):
Request a Feature or Component