通过Node.js和C++为Excel工作簿的VBA项目设置密码保护

在Node.js中为Excel工作簿的VBA项目设置密码保护

你可以使用VbaProject.protect(boolean, string)方法用Aspose.Cells为工作簿的VBA(Visual Basic for Applications)项目设置密码保护。

示例代码

以下示例代码加载示例Excel文件,访问其VBA项目并设置密码保护,最后将其保存为输出Excel文件

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

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

// Load your source Excel file.
const workbook = new AsposeCells.Workbook(path.join(dataDir, "samplePasswordProtectVBAProject.xlsm"));

// Access the VBA project of the workbook.
const vbaProject = workbook.getVbaProject();

// Lock the VBA project for viewing with password.
vbaProject.protect(true, "11");

// Save the output Excel file
workbook.save(path.join(dataDir, "outputPasswordProtectVBAProject.xlsm"));