Freeze panes of Excel Worksheet with Node.js via C++

Introduction

In this article, we will learn how to freeze panes. When you have a huge amount of data under a common heading, you cannot see the heading when you scroll down the worksheet. Each record contains many data fields. You can freeze panes so that you can see that frozen portion even when the rest of the data is being scrolled. You can easily see headers in the top rows or first columns. Freezing and unfreezing panes only changes the view of the data without changing the data itself.

In Excel

1. If you want to freeze panes, freeze rows and columns, then first select a cell (such as B2).
2. Click View > Freeze Panes.
3. On the drop‑down menu, click Freeze Panes.
4. If you scroll down or right, the first row and column are frozen.

As you can see, 1st row and column A are frozen; the second row is 32 and the second visible column is D.

Freeze panes let you view your large data without having to keep track of row or column labels.

Freeze Panes with Aspose.Cells for Node.js via C++

It’s simple to freeze panes with Aspose.Cells for Node.js via C++. Please use the Worksheet.freezePanes(number, number, number, number) method to freeze panes at the selected cell.

1. Construct a Workbook to open a file or create an empty one.
2. Freeze panes with the Worksheet.freezePanes() method.
3. Save the file.

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

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
// Instantiate a new Workbook.
const workbook = new AsposeCells.Workbook(path.join(dataDir, "Freeze.xlsx")); 
// Freezing panes at the cell B2
workbook.getWorksheets().get(0).freezePanes("B2", 1, 1);
// Saving the file
workbook.save("frozen.xlsx");

Attached sample source Excel file.