Hello,
I am trying to obtain "freeze panes" properties for a worksheet so that I can adjust for deleted/inserted rows and columns in a Worksheet.
There is mention of a Worksheet method "GetFreezedPanes()" in some previous threads but I can't find it in the current release of Aspose.Cells. (4.7.1)
Is there some other way to find out?
Bill
Hi Bill,
Thank you for considering Aspose.
Well, I checked and Worksheet.GetFreezedPanes is available in the latest version of Aspose.Cells (V4.7.1). Following is my sample code:
Sample Code:
Workbook wb = new Workbook();
wb.Open(@"F:\FileTemp\test.xls");
Worksheet sheet = wb.Worksheets[0];
int row, column, rows, columns;
sheet.GetFreezedPanes(out row, out column, out rows, out columns);
sheet.UnFreezePanes();
wb.Save(@"F:\FileTemp\dest.xls");
Also, I have attached the latest version of Aspose.Cells. Please try it and let us know if you still face any problem.
Thank You & Best Regards,