Unfreeze Rows or Columns with Node.js via C++
Contents
[
Hide
]
Introduction
In this article, we will learn how to unfreeze rows, columns, and panes. If worksheets in the Excel files are frozen, sometimes we want to unfreeze the worksheet or adjust frozen rows, columns, or panes.
In Excel
- Click View tab > Freeze Panes > Unfreeze Panes.
Unfreeze Rows, Columns or Panes with Aspose.Cells for Node.js via C++
It’s simple to unfreeze panes with Aspose.Cells for Node.js via C++. Please use the Worksheet.unFreezePanes() method to unfreeze panes.
- Construct Workbook to open the frozen file.
- Unfreeze panes with Worksheet.unfreezePanes() method.
- Save the file.
const path = require("path");
const AsposeCells = require("aspose.cells.node");
const dataDir = path.join(__dirname, "data");
const frozenFilePath = path.join(dataDir, "Frozen.xlsx");
const workbook = new AsposeCells.Workbook(frozenFilePath);
workbook.getWorksheets().get(0).unFreezePanes();
workbook.save("Unfrozen.xlsx");
Attached sample source Excel file.