At the moment I am evaluating the Spire.Xsl library (using the trial version). I was very happy with the merging process (I managed to merge two excel files each with 350k rows into one without getting out of memory exception). Right now I am trying to simply export a dataTable with 350k rows into a new excel file. However when I try to save it I end up only with 65k rows. Any ideas why?
I am using the following code:
- Code: Select all
Workbook book = new Workbook();
Worksheet sheet = book.Worksheets[0];
sheet.InsertDataTable(dataTable, true, 1, 1);
book.SaveToFile("insertTableToExcel.xlsx", ExcelVersion.Version2013);