通过 Node.js 和 C++ 将源工作表的页面设置复制到目标工作表
Contents
[
Hide
]
可能的使用场景
当你在工作簿中添加新工作表时,它包含默认的页面设置。有时你需要将一个工作表的设置(PageSetup)传输到另一个工作表。本文件介绍如何使用 Aspose.Cells for Node.js via C++ API 将页面设置从一个工作表复制到另一个工作表。
将源工作表中的页面设置复制到目标工作表
以下示例代码说明了如何使用PageSetup.copy(PageSetup, CopyOptions)方法从一个工作表复制页面设置到另一个工作表。请查看以下示例代码及其控制台输出以供参考。
示例代码
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, "sample.xlsx");
// Create workbook
const wb = new AsposeCells.Workbook();
// Add two test worksheets
wb.getWorksheets().add("TestSheet1");
wb.getWorksheets().add("TestSheet2");
// Access both worksheets as TestSheet1 and TestSheet2
const TestSheet1 = wb.getWorksheets().get("TestSheet1");
const TestSheet2 = wb.getWorksheets().get("TestSheet2");
// Set the Paper Size of TestSheet1 to PaperA3ExtraTransverse
TestSheet1.getPageSetup().setPaperSize(AsposeCells.PaperSizeType.PaperA3ExtraTransverse);
// Print the Paper Size of both worksheets
console.log("Before Paper Size: " + TestSheet1.getPageSetup().getPaperSize());
console.log("Before Paper Size: " + TestSheet2.getPageSetup().getPaperSize());
console.log();
// Copy the PageSetup from TestSheet1 to TestSheet2
TestSheet2.getPageSetup().copy(TestSheet1.getPageSetup(), new AsposeCells.CopyOptions());
// Print the Paper Size of both worksheets
console.log("After Paper Size: " + TestSheet1.getPageSetup().getPaperSize());
console.log("After Paper Size: " + TestSheet2.getPageSetup().getPaperSize());
console.log();
控制台输出
Before Paper Size: PaperA3ExtraTransverse
Before Paper Size: PaperLetter
After Paper Size: PaperA3ExtraTransverse
After Paper Size: PaperA3ExtraTransverse