Write each Excel worksheet to a separate PDF

This Java sample uses Qoppa’s PDF conversion library jOfficeConvert to convert each worksheet of a Microsoft Excel workbook to a PDF document, using the worksheet name as the PDF file name.

// Load the document
ExcelDocument ed = new ExcelDocument("C:\\test\\input.xlsx", new ExcelConvertOptions());
List<String> workSheetNames = ed.getWorkSheetNames();
 
for (String name : workSheetNames)
{
 List<String> namesList = Collections.singletonList(name);
 ed.setWorksheetsToConvert(namesList);
 ed.saveAsPDF(name + ".pdf");
}
Tagged: