I am attempting to save a large dataset to an excel file. Large = 51000 rows, 16 columns. Does this exceed Aspose.Excel's capabilities? Some columns contain blanks. The leftmost column does not contain any blanks.
---------------------------------
Exception Details: System.Exception: Aspose.Excel cannot shift nonblank cell off the worksheet.
Source Error:
Line 54: excel.Worksheets[0].Cells.ImportDataTable(ds.Tables[TableIndex],true, 1, 1);
Line 55:
Line 56: sheet.Cells.ImportDataTable(ds.Tables[0], true, 1, 1); <-- exception is here
Line 57: excel.Save(FileNameNoExtension, Aspose.Excel.FileFormatType.Excel2003);