Getting Invalid row index error when using ooxmlsaveoptiosn

Aspose.Cells Product Family
1

Hi

I’m using Aspose cells version 7.1.1.0.
Here is the code I’m using:
1. Dim stream As New MemoryStream()
2. Dim workbook As New Workbook( “SomeFile.xls”)
3. ’ add some data to the work book
4. workbook.Worksheets(0).FreezePanes(5, 5, 6, 6)
5. workbook.Save(
stream , New OoxmlSaveOptions())

at line 5 I’m getting exception with message : Invalid Row Index.

Thanks and Regards
Mukundan
2

Hi,


Please try to change the line:
workbook.Worksheets(0).FreezePanes(5, 5, 6, 6)
to:
workbook.Worksheets(0).FreezePanes(5, 5, 5, 5)

If you still find the issue, kindly attach your template file here.

Thank you.