Export to Excel Row Limitation

[Armando]

Hi,

I did a search on the forums and I didn't run into this question so hopefully I'm in the right area.

My client has a need for more rows to be exported into an Excel file from the RadGrid. I'm pretty sure that the limit for Excel '97-2003 is 65,536. They are using Excel 2007 on their desktop machines now, which is capable of handling many more rows. I know the RadGrid exports to '97-2003 so I know that limit would exist. Is there a hotfix for the RadGrid to be able to export to Excel 2007 or at least more than the 65,536 row limitation of Excel '97-2003?

Thanks for your time,
~Armando

[Daniel]

Hello Armando,

In theory you can export more than 65,535 rows, however you should re-save the file to XLSX in order to avoid losing data.

The problem is that our export is not suitable for exporting such amount of data. In other words, this would work only in simple scenarios where the number of columns is small.

Regards,
Daniel
the Telerik team