从源工作表复制页面设置设置到目标工作表的可能使用场景

可能的使用场景

当您向工作簿添加新工作表时,它包含默认的页面设置。有时您需要将页面设置(PageSetup)从一个工作表转移到另一个工作表。本文解释了如何使用Aspose.Cells APIs从一个工作表复制页面设置到另一个工作表。

将源工作表中的页面设置复制到目标工作表

以下示例代码说明了如何使用PageSetup.Copy()方法从一个工作表复制页面设置到另一个工作表。请查看以下示例代码及其控制台输出以供参考。

示例代码

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
//Create workbook
Workbook wb = new Workbook();
//Add two test worksheets
wb.Worksheets.Add("TestSheet1");
wb.Worksheets.Add("TestSheet2");
//Access both worksheets as TestSheet1 and TestSheet2
Worksheet TestSheet1 = wb.Worksheets["TestSheet1"];
Worksheet TestSheet2 = wb.Worksheets["TestSheet2"];
//Set the Paper Size of TestSheet1 to PaperA3ExtraTransverse
TestSheet1.PageSetup.PaperSize = PaperSizeType.PaperA3ExtraTransverse;
//Print the Paper Size of both worksheets
Console.WriteLine("Before Paper Size: " + TestSheet1.PageSetup.PaperSize);
Console.WriteLine("Before Paper Size: " + TestSheet2.PageSetup.PaperSize);
Console.WriteLine();
//Copy the PageSetup from TestSheet1 to TestSheet2
TestSheet2.PageSetup.Copy(TestSheet1.PageSetup, new CopyOptions());
//Print the Paper Size of both worksheets
Console.WriteLine("After Paper Size: " + TestSheet1.PageSetup.PaperSize);
Console.WriteLine("After Paper Size: " + TestSheet2.PageSetup.PaperSize);
Console.WriteLine();

控制台输出

Before Paper Size: PaperA3ExtraTransverse

Before Paper Size: PaperLetter

After Paper Size: PaperA3ExtraTransverse

After Paper Size: PaperA3ExtraTransverse