限制生成的页面数量 将Excel转换为PDF
Contents
[
Hide
]
有时,你想将页面范围打印到一个输出PDF文件。Aspose.Cells可以设置在将Excel电子表格转换为PDF时生成多少页的限制。
限制生成的页面数量
以下示例显示了如何将Microsoft Excel文件的页面范围(第3页和第4页)呈现为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(LimitNumberofPagesGenerated.class); | |
// Open an Excel file | |
Workbook wb = new Workbook(dataDir + "TestBook.xlsx"); | |
// Instantiate the PdfSaveOption | |
PdfSaveOptions options = new PdfSaveOptions(); | |
// Print only Page 3 and Page 4 in the output PDF | |
// Starting page index (0-based index) | |
options.setPageIndex(2); | |
// Number of pages to be printed | |
options.setPageCount(2); | |
// Save the PDF file | |
wb.save(dataDir + "outPDF1.pdf", options); |
如果电子表格中包含公式,最好在将其渲染为 PDF 格式前调用 Workbook.calculateFormula。这样做可以确保重新计算公式依赖的值,并在输出文件中呈现正确的值。