将每个工作表保存为不同的PDF文件

Contents
[ ]

如果您需要保存模板 Excel 文件中的每个工作表以生成不同的 PDF 文件,这可以很容易地实现。您可以尝试一次将一个工作表索引设置为 PdfSaveOptions.SheetSet 选项,以生成 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(SaveEachWorksheettoDifferentPDF.class);
// Instantiate a new workbook and open the Excel
// File from its location
Workbook workbook = new Workbook(dataDir + "input.xlsx");
// Get the count of the worksheets in the workbook
int sheetCount = workbook.getWorksheets().getCount();
// Define PdfSaveOptions
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
// Take Pdfs of each sheet
for (int j = 0; j < sheetCount; j++) {
Worksheet ws = workbook.getWorksheets().get(j);
//set worksheet to output
SheetSet sheetSet = new SheetSet(new int[] { ws.getIndex() });
pdfSaveOptions.setSheetSet(sheetSet);
workbook.save(dataDir + "_" + ws.getName() + ".pdf", pdfSaveOptions);
}