Hi Team,
Hi,
Hi,
LoadOptions lo = new LoadOptions(LoadFormat.TabDelimited);
lo.MemorySetting = MemorySetting.MemoryPreference;
lo.CheckExcelRestriction = false;
Workbook workbook = new Workbook(FileName, lo);
Worksheet wsheet = workbook.Worksheets[0];
ExportTableOptions exptableoption = new ExportTableOptions { SkipErrorValue = false, ExportColumnName = true, CheckMixedValueType = true };
dtable = wsheet.Cells.ExportDataTable(0, 0, wsheet.Cells.MaxRow, wsheet.Cells.MaxColumn, exptableoption);
In the above line at ExportDataTable we are getting Invalid Row end index provided.
Hi,
Hi,
Hi,
Hi,
Hi Tamal Mukherjee,
Is this still the case @Amjad_Sahi , coz now in 2019, I really want to use Aspose to write into CSV, not go via traditional FileWriter route.
Regards,
Kushagra Sahni
Well, could you provide us your template CSV/Tab Delimited file which you could create manually in Ms Excel. and which you are loading via Aspose.Cells APIs, so we could evaluate your issue. If the file is larger in size, you may zip it and upload to some free drive/space(e.g dropbox etc.) and provide shared link or URL to download it.
Also, open your desired CSV file into MS Excel, what is your last row index you see in the worksheet. MS Excel only allows you to have a maximum of 1048576 rows for a worksheet (you cannot save/load more data than this limitation), so you cannot cross this limit. For your information, Aspose.Cells follows MS Excel standards and specifications for MS Excel file formats and cannot go beyond it.
I somehow want to ignore the MS Excel Standard as I am anyway gonna save the file in CSV, and yes the row count is far beyond the number 1048576!
I am afraid, you might not be able to access the data even we load it into a workbook object mode. If you just want to open and save again for the CSV file, it is possible, but we do not think it would be meaningful or provide any benefit to you. For such kind of files, the better solution is you split the file by yourself and then import it into multiple workbooks/Worksheets. You can split the file into multi-files, or, just create one custom Reader from the file which could split the file and then load the data into cells by the custom reader.