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
570
About UltraGridExcelExporter
posted

When the UltraGrid's data is beyond Excel's max row,  if I used UltraGridExcelExporter control Export UltraGrid's data, it whether have error?  If it has problem, how can I resolve?  Please help me.

  • 12773
    posted

    Hello,

    The MS Excel 2007 support big amount of data. In order to implement it in your project you need to use xlsx format when you export your grid. See this code snipped:

    string fileName = Path.Combine(Path.GetDirectoryName(Application.ExecutablePath), "x.xlsx");
    this.ultraGridExcelExporter1.Export(this.ultraGrid1, fileName, Infragistics.Excel.WorkbookFormat.Excel2007);

    Also you need to get the latest service release in order to avoid this restrictions.

    Let me know if this helps.

    Sincerely,
    Dimi
    Developer Support Engineer
    Infragistics, Inc.