How to Check Frozen State without Excel.

Introduction

In this article, we will learn how to check the frozen state of an Excel worksheet programmatically. We can simply determine whether the worksheet is frozen or split in MS Excel. But is there a way to find whether it is frozen or split using C#? We can easily do it with Aspose.Cells for Python via .NET.

How to Check Frozen State

With Aspose.Cells for Python via .NET, we can check whether the window is frozen and how many rows and columns are locked.

Please use the Worksheet.pane_state property to check the state of window panes and get locked rows and columns with Worksheet.get_freezed_panes method.

1. Construct a Workbook to open the file.
2. Check whether the worksheet is frozen.
3. Get the locked rows and columns.