Not able to convert large Html file to Excel using Aspose.Cells for .Net

Aspose.Cells Product Family
1

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
2

Is it because of this?

3

Ok, I think the limit is the issue. It is the limit for Excel which described in Microsoft specification as well.
This issue is closed.

4

@fonglun,

It seems you got it now. Aspose.Cells follows MS Excel standards and specifications when parsing or rendering Excel spreadsheets.

In the event of further queries or issue, feel free to write us back and we will be happy to assist you soon.

1 Like