限制生成的页面数量 将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-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// 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.PageIndex = 3; | |
// Number of pages to be printed | |
options.PageCount = 2; | |
// Save the PDF file | |
wb.Save(dataDir+ "outPDF1.out.pdf", options); |
如果电子表格中包含公式,最好在将其呈现为PDF文件之前调用Workbook.CalculateFormula()。这样可以确保重新计算公式相关值,并在输出文件中呈现正确的值。