I am trying to convert Excel to PDF but my output PDF has rows that overlap with each other. Sheet name is also printed on top of every page which i don’t want to.
Here is the code used to perform conversion:
PdfSaveOptions saveOptions = new PdfSaveOptions();
saveOptions.setAllColumnsInOnePagePerSheet(true);
saveOptions.setOptimizationType(PdfOptimizationType.STANDARD);
saveOptions.setTextCrossType(TextCrossType.DEFAULT);
saveOptions.setCalculateFormula(true);
saveOptions.setCheckWorkbookDefaultFont(true);
saveOptions.setIgnoreError(true);
excelFile.save(output, saveOptions);
Input excel and output PDF files are also attachedexcelToPdf.zip (229.8 KB)