Forums Ultimate UI for Windows Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
lasting
2715
UltraGridExcelExporter exporter limit
posted

Hi!

I've worked with Excel 2003 and Excel 2007 in the past, and I know about the 65k rows in a sheet limit in Excel 2003.

I use UltraGridExcelExporter to export a grid, so I need to know if this issue exists for the Exporter - can it export more that 65k rows in a sheet ?

Thanks!

  • 12773
    Verified Answer
    posted

    Hello,

    This is limitation of the MS Excel 2003 file format. Generally the .xls file format is not supporting more than 65,536 rows.
    You can find similar discussion here:
    http://community.infragistics.com/forums/p/33116/232324.aspx#232324
    where I have attach sample avoiding this limitation by exporting the data in new sheet.

    MS Excel 2007 didn’t have this limitation and exporting to .xlsx you should be able to get all of the data exported correctly. Also I am suggesting you to get the latest service release if you are using older versions.

    I hope this helps.

    Sincerely,
    Dimi
    Developer Support Engineer
    Infragistics, Inc.