Hello,
I am using Infragistics.Win.UltraWinGrid.ExcelExport V5.1, this is having export limitation on rows, cannot export more than 65000 rows. I am trying for more than 100000 rows to export.
Please suggest me in which version this feature is included so I can go ahead upgrade it to that version.
Any help much appreciated.
Hello Pravin,
Please clarify the Infragistics version that you are using, is it 5.1? We are not imposing any limit on the number of rows that can be exported but Excel does. Excel versions prior to 2007 have a row limitation of 65,536. Since Excel2007 this limitation is removed. Refer to this link to read more about it. You can export the Grid to an xlsx file to resolve this issue.
Also once I receive the Infragistics version information, I will check if it supports exporting to xlsx.
Let me know if you have any questions.