How to Check Frozen State without Excel Using Node.js via C++

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 determine whether it is frozen or split using Node.js? We can easily do it with Aspose.Cells for Node.js via C++.

Are Window Panes Frozen?

With Aspose.Cells for Node.js via C++, we can check whether the window panes are frozen and how many rows and columns are locked.

Please use the Worksheet.getPaneState() property to check the state of window panes and get locked rows and columns with the Worksheet.getFreezedPanes() method.

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

try {
    const AsposeCells = require("aspose.cells.node");
    const path = require("path");

    // The path to the documents directory.
    const dataDir = path.join(__dirname, "data");
    const filePath = path.join(dataDir, "Frozen.xlsx");

    // Loads the workbook which contains frozen panes
    const workbook = new AsposeCells.Workbook(filePath);
    const sheet = workbook.getWorksheets().get(0);

    // Check whether worksheet is frozen.
    if (sheet.getPaneState() === AsposeCells.PaneStateType.Frozen ||
        sheet.getPaneState() === AsposeCells.PaneStateType.FrozenSplit) {
        let row, column, rows, columns;
        // Gets locked rows and columns.
        sheet.getFreezedPanes().forEach((value) => {
            row = value[0];
            column = value[1];
            rows = value[2];
            columns = value[3];
        });
    }
} catch (e) {
    console.error(e);
}