How do I obtain "Freeze panes" properties

Aspose.Cells Product Family
1

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

2

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,