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

可能的使用场景

向工作簿添加新工作表时,它包含默认的页面设置。有时您需要将一个工作表的设置(PageSetup)传输到另一个工作表。本文档介绍如何使用Aspose.Cells API将一个工作表的页面设置复制到另一个工作表。

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

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

示例代码

// 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