加载指定打印纸张大小的工作簿

加载带有指定打印纸张大小的工作簿

以下示例代码说明了LoadOptions.setPaperSize()方法的用法。它首先创建一个工作簿,然后以XLSX格式将其保存在字节数组流中。然后将其以A5纸张大小加载,并以PDF格式保存。然后以A3纸张大小再次加载并再次以PDF格式保存。如果您打开输出的PDF并检查其纸张大小,您将看到它们是不同的。一个是A5,另一个是A3。请根据提供的代码下载由该代码生成的A5输出PDFA3输出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");