I am using Aspose.Cells for .Net, I am trying to convert a simple but large Html file to Excel, but it failed with error message “Invalid row index.74805”
Is there a maximum size limit of the Html file when converting to Excel using Aspose.Cells for .Net?
I’ve tried and found out that Html file with size greater than 80MB will failed with “Invalid row index.”.
The Html file is 80,018,670 bytes in size, and I am able to open the Html file in web browser.
This is the codes I used to do the conversion.
Using wb As New Workbook("C:\LargeHtmlFile.html", New HtmlLoadOptions()) wb.Worksheets(0).AutoFitColumns() wb.Save("C:\GeneratedExcelFile.xlsx", SaveFormat.Xlsx) End Using