Protect and Unprotect Workbook Structure with Node.js via C++

To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.

Protect and Unprotect Workbook Structure in MS Excel

1. Click Review > Protect Workbook.
2. Enter a password in the Password box.
3. Select OK, re‑enter the password to confirm it, and then select OK again.

Protect Workbook Structure Using Aspose.Cells for Node.js via C++

Only the following simple lines of code are needed to implement protecting the workbook structure of Excel files.

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

// The path to the documents directory.
const dataDir = path.join(__dirname, "data");
const filePath = path.join(dataDir, "Book1.xlsx");
// Create a new file.
const workbook = new AsposeCells.Workbook();
// Protect workbook structure.
workbook.protect(AsposeCells.ProtectionType.Structure, "password");
// Save Excel file.
workbook.save(filePath);

Unprotect Workbook Structure Using Aspose.Cells for Node.js via C++

Unprotecting workbook structure is easy with the Aspose.Cells API.

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

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

// Open an Excel file whose workbook structure is protected.
const workbook = new AsposeCells.Workbook(filePath);
// Unprotect workbook structure.
workbook.unprotect("password");
// Save Excel file.
workbook.save(filePath);

Note: a correct password is required.