加载指定打印纸张大小的工作簿
Contents
[
Hide
]
您可以在加载工作簿时使用LoadOptions.setPaperSize()方法指定您选择的打印纸张大小。请注意,如果在MS Excel中创建新文件,则会发现纸张大小与您机器上默认打印机的设置相同。
加载带有指定打印纸张大小的工作簿
以下示例代码说明了LoadOptions.setPaperSize()方法的用法。它首先创建一个工作簿,然后以XLSX格式将其保存在字节数组流中。然后将其以A5纸张大小加载,并以PDF格式保存。然后以A3纸张大小再次加载并再次以PDF格式保存。如果您打开输出的PDF并检查其纸张大小,您将看到它们是不同的。一个是A5,另一个是A3。请根据提供的代码下载由该代码生成的A5输出PDF和A3输出PDF进行参考。
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 | |
// 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"); |