加载具有指定打印机纸张尺寸的工作簿

您可以在使用加载工作簿时指定您选择的打印机纸张尺寸[LoadOptions.setPaperSize()方法](https://reference.aspose.com/cells/java/com.aspose.cells/loadoptions#setPaperSize(int)） 方法。请注意，如果您在 MS Excel 中创建一个新文件，您会发现纸张尺寸与您机器中默认打印机的设置相同。

加载具有指定打印机纸张尺寸的工作簿

下面的示例代码说明了[LoadOptions.setPaperSize()方法](https://reference.aspose.com/cells/java/com.aspose.cells/loadoptions#setPaperSize(int)） 方法。它首先创建一个工作簿，然后将它以XLSX 格式保存在字节数组流中。然后加载 A5 纸张大小并以 PDF 格式保存。然后它再次加载 A3 纸张大小并再次以 PDF 格式保存。如果您打开输出的 PDF 并检查它们的纸张大小，您会发现它们是不同的。一个是A5，另一个是A3。请下载A5输出PDF和A3输出PDF生成的代码供大家参考。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(LoadWorkbook.class);

// Create a sample workbook and add some data inside the first worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getCells().get("P30").putValue("This is sample data.");

// Save the workbook in memory stream
ByteArrayOutputStream baout = new ByteArrayOutputStream();
workbook.save(baout, SaveFormat.XLSX);

// Get bytes and create byte array input stream
byte[] bts = baout.toByteArray();
ByteArrayInputStream bain = new ByteArrayInputStream(bts);

// Now load the workbook from memory stream with A5 paper size
LoadOptions opts = new LoadOptions(LoadFormat.XLSX);
opts.setPaperSize(PaperSizeType.PAPER_A_5);
workbook = new Workbook(bain, opts);

// Save the workbook in pdf format
workbook.save(dataDir + "output-a5.pdf");

// Now load the workbook again from memory stream with A3 paper size
opts = new LoadOptions(LoadFormat.XLSX);
opts.setPaperSize(PaperSizeType.PAPER_A_3);
workbook = new Workbook(bain, opts);

// Save the workbook in pdf format
workbook.save(dataDir + "output-a3.pdf");