将源工作表中的页面设置设置复制到目标工作表
Contents
[
Hide
]
可能的使用场景
当您将新工作表添加到工作簿时，它包含默认的页面设置设置。有时您可能需要传输设置（页面设置) 从一个工作表到另一个工作表。本文档说明如何使用 Aspose.Cells API 将页面设置设置从一个工作表复制到另一个工作表。
将源工作表中的页面设置设置复制到目标工作表
以下示例代码说明了如何使用以下方法将页面设置设置从一个工作表复制到另一个工作表[PageSetup.Copy()](https://reference.aspose.com/cells/java/com.aspose.cells/pagesetup#copy(com.aspose.cells.PageSetup,%20com.aspose.cells.CopyOptions)） 方法。请参阅以下示例代码及其控制台输出以供参考。
示例代码
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-Java | |
| //Converting integer enums to string enums | |
| HashMap<Integer, String> paperSizeTypes = new HashMap<Integer, String>(); | |
| paperSizeTypes.put(PaperSizeType.PAPER_A_3_EXTRA_TRANSVERSE, "PAPER_A_3_EXTRA_TRANSVERSE"); | |
| paperSizeTypes.put(PaperSizeType.PAPER_LETTER, "PAPER_LETTER"); | |
| //Create workbook | |
| Workbook wb = new Workbook(); | |
| //Add two test worksheets | |
| wb.getWorksheets().add("TestSheet1"); | |
| wb.getWorksheets().add("TestSheet2"); | |
| //Access both worksheets as TestSheet1 and TestSheet2 | |
| Worksheet TestSheet1 = wb.getWorksheets().get("TestSheet1"); | |
| Worksheet TestSheet2 = wb.getWorksheets().get("TestSheet2"); | |
| //Set the Paper Size of TestSheet1 to PaperA3ExtraTransverse | |
| TestSheet1.getPageSetup().setPaperSize(PaperSizeType.PAPER_A_3_EXTRA_TRANSVERSE); | |
| //Print the Paper Size of both worksheets | |
| System.out.println("Before Paper Size: " + paperSizeTypes.get(TestSheet1.getPageSetup().getPaperSize())); | |
| System.out.println("Before Paper Size: " + paperSizeTypes.get(TestSheet2.getPageSetup().getPaperSize())); | |
| System.out.println(); | |
| //Copy the PageSetup from TestSheet1 to TestSheet2 | |
| TestSheet2.getPageSetup().copy(TestSheet1.getPageSetup(), new CopyOptions()); | |
| //Print the Paper Size of both worksheets | |
| System.out.println("After Paper Size: " + paperSizeTypes.get(TestSheet1.getPageSetup().getPaperSize())); | |
| System.out.println("After Paper Size: " + paperSizeTypes.get(TestSheet2.getPageSetup().getPaperSize())); | |
| System.out.println(); |
控制台输出
Before Paper Size: PAPER_A_3_EXTRA_TRANSVERSE
Before Paper Size: PAPER_LETTER
After Paper Size: PAPER_A_3_EXTRA_TRANSVERSE
After Paper Size: PAPER_A_3_EXTRA_TRANSVERSE