从源工作表复制页面设置设置到目标工作表的可能使用场景
Contents
[
Hide
]
可能的使用场景
当您向工作簿添加新工作表时,它包含默认的页面设置。有时您需要将页面设置(PageSetup)从一个工作表转移到另一个工作表。本文解释了如何使用Aspose.Cells APIs从一个工作表复制页面设置到另一个工作表。
将源工作表中的页面设置复制到目标工作表
以下示例代码说明了如何使用PageSetup.Copy()方法从一个工作表复制页面设置到另一个工作表。请查看以下示例代码及其控制台输出以供参考。
示例代码
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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