PDF Export Options

// Create a new workbook.
Workbook workbook = new Workbook();
        
// Open template file.
workbook.open("CustomBorderStyle.xlsx");

// Customize the border style for PDF export.
// Initialize PdfSaveOptions.
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
        
// Set outer border width to 0.4.
CustomBorderStyle thinBorderSetting = new CustomBorderStyle();
thinBorderSetting.setBorderWidth(0.4);
        
// Set middle border width to 1.5.
CustomBorderStyle middleBorderSetting = new CustomBorderStyle();
middleBorderSetting.setBorderWidth(1.5);
        
// Set inner horizontal border width to 0.4 in dash style.
CustomBorderStyle dashBorderSetting = new CustomBorderStyle();
dashBorderSetting.setBorderWidth(0.4);
dashBorderSetting.setDashes(new ArrayList<>(Arrays.asList(0.8, 0.8)));
        
// Add borders with custom border styles.
pdfSaveOptions.getBorderOptions().put(BorderLineStyle.Thin, thinBorderSetting);
pdfSaveOptions.getBorderOptions().put(BorderLineStyle.Medium, middleBorderSetting);
pdfSaveOptions.getBorderOptions().put(workbook.getActiveSheet().getRange("B13").getBorders().get(BordersIndex.EdgeTop).getLineStyle(), dashBorderSetting);
        
// Save workbook to PDF file.
workbook.save("CustomBorder.pdf", pdfSaveOptions);

// Initialize workbook.
Workbook workbook = new Workbook();
        
// Fetch default worksheet.
IWorksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getPageSetup().setPrintGridlines(true);
worksheet.getRange("A1").setRowHeightInPixel(20);
worksheet.getRange("A1").setColumnWidthInPixel(90);
worksheet.getRange("A1").setWrapText(true);
worksheet.getRange("A1").setShrinkToFit(true);
worksheet.getRange("A1").setValue("Document Solutions For Excel");

// Setting PdfSaveOptions.
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.getShrinkToFitSettings().setCanShrinkToFitWrappedText(true);
pdfSaveOptions.getShrinkToFitSettings().setMinimumFont(10);
pdfSaveOptions.getShrinkToFitSettings().setEllipsis("~");

// Saving the workbook to pdf.
workbook.save("ShrinkToFitWrappedText.pdf", pdfSaveOptions);

// Initialize workbook
Workbook workbook = new Workbook();
// Fetch default worksheet
IWorksheet worksheet = workbook.getWorksheets().get(0);
Object data = new Object[][] { { "Name", "City", "Sex", "Weight", "Height", "Age" },
        { "Bob", "NewYork", "male", 80, 180, 56 }, { "Betty", "NewYork", "female", 72, 168, 45 },
        { "Gary", "NewYork", "male", 71, 179, 50 }, { "Hunk", "Washington", "male", 80, 171, 59 },
        { "Cherry", "Washington", "female", 58, 161, 34 }, { "Coco", "Virginia", "female", 58, 181, 45 },
        { "Lance", "Chicago", "female", 49, 160, 57 }, { "Eva", "Washington", "female", 71, 180, 81 } };

worksheet.setName("Listing");
// Set data
worksheet.getRange("A1:G9").setValue(data);

// The security settings of pdf when converting excel to pdf
PdfSecurityOptions securityOptions = new PdfSecurityOptions();
// Sets the user password
securityOptions.setUserPassword("user");
// Sets the owner password
securityOptions.setOwnerPassword("owner");
// Printing the pdf document is not allowed
securityOptions.setPrintPermission(false);
// Filling the form fields of the pdf document is not allowed
securityOptions.setFillFormsPermission(false);

PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
// Sets the security settings of the pdf
pdfSaveOptions.setSecurityOptions(securityOptions);

// Saving workbook to PDF
workbook.save("4-SavePDFPdfSecurityOptions.pdf", pdfSaveOptions);

//create to a pdf file stream
FileOutputStream outputStream = null;
try {
    outputStream = new FileOutputStream("SetDocumentPropertiesToPDF.pdf");
} catch (FileNotFoundException e) {
    e.printStackTrace();
}
//create a new workbook
Workbook workbook = new Workbook();

IWorksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getRange("A1").setValue("Document Solutions for Excel");
worksheet.getRange("A1").getFont().setSize(25);

DocumentProperties documentProperties = new DocumentProperties();
//Sets the name of the person that created the PDF document.
documentProperties.setAuthor("Jaime Smith");
//Sets the title of thePDF document.
documentProperties.setTitle("DsPdf Document Info Sample");
//Set the PDF version.
documentProperties.setPdfVersion(1.5f);
//Set the subject of the PDF document.
documentProperties.setSubject("DsPdfDocument.DocumentInfo");
//Set the keyword associated with the PDF document.
documentProperties.setKeywords("Keyword1");
//Set the creation date and time of the PDF document.
documentProperties.setCreationDate(new GregorianCalendar(2019,5,24));
//Set the date and time the PDF document was most recently modified.
documentProperties.setModifyDate(new GregorianCalendar(2020,5,24));
//Set the name of the application that created the original PDF document.
documentProperties.setCreator("DsPdfWeb Creator");
//Set the name of the application that created the PDF document.
documentProperties.setProducer("DsPdfWeb Producer");


PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
//Sets the document properties of the pdf.
pdfSaveOptions.setDocumentProperties(documentProperties);

Workbook workbook = new Workbook();
// Fetch default worksheet
IWorksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getRange("A1").setValue("Document Solutions for Excel");
worksheet.getRange("A1").getFont().setSize(25);

// Load an image from a specific file in input stream
InputStream inputStream = ClassLoader.getSystemResourceAsStream("background-picture.png");
try {
    byte[] bytes = new byte[inputStream.available()];
    // Read an image from input stream
    inputStream.read(bytes, 0, bytes.length);

    // Add background image of the worksheet
    worksheet.setBackgroundPicture(bytes);
} catch (IOException ioe) {
    ioe.printStackTrace();
}

PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
// Print the background picture in the centre of exported pdf file
pdfSaveOptions.setPrintBackgroundPicture(true);

// Saving workbook to pdf
workbook.save("12-PrintBackgroundPicture.pdf", pdfSaveOptions);

Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().get(0);
            
//Add a background picture in the worksheet
IBackgroundPicture picture1 = worksheet.getBackgroundPictures().addPictureInPixel("image.png", 10, 10, 250, 150);
IBackgroundPicture picture2 = worksheet.getBackgroundPictures().addPictureInPixel("ConvertShapeToImage.png", 180, 10, 150, 100);

//Set the border style of the destination rectangle.
picture1.getLine().getColor().setRGB(Color.GetGray());
picture1.getLine().setWeight(1);

//The background picture will be resized to fill the destination dimensions.The aspect ratio is not preserved.
picture1.setBackgroundImageLayout(ImageLayout.Stretch);

//Sets the rounded corner of the destination rectangle.
picture1.setCornerRadius(50);
//Sets the transparency of the background picture.
picture1.setTransparency(0.5);
picture2.setTransparency(0.5);

//Save to PDF file
workbook.save("ExportBackgroundImageToPDF.pdf");

// Initialize workbook.
Workbook workbook = new Workbook();

// Fetch default worksheet.
IWorksheet worksheet = workbook.getWorksheets().get(0);

worksheet.getRange("A1:K20").getInterior().setColor(Color.FromArgb(50, 0, 255, 255));
    
// Add a background picture.
IBackgroundPicture picture = worksheet.getBackgroundPictures().addPictureInPixel("image.png", 0, 0, 300, 200);
      
// Set the transparency of cell's background color, so the background picture will come out to the front.
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.setPrintTransparentCell(true);
         
// Save to pdf file.
workbook.save("PrintTransparentCell.pdf", pdfSaveOptions);

// Create to a pdf file stream
FileOutputStream outputStream = null;
try {
    outputStream = new FileOutputStream("PagePrintEventsTrackProgress.pdf");
} catch (FileNotFoundException e) {
    e.printStackTrace();
}
// Create a new workbook
Workbook workbook = new Workbook();
IWorksheet activeSheet = workbook.getActiveSheet();
activeSheet.getRange("A1").setValue(1);
activeSheet.getRange("A2:A100").setFormulaR1C1("=R[-1]C+1");
PdfSaveOptions options = new PdfSaveOptions();
options.getPagePrintingEvent().addListener(
(sender, e) -> System.out.println(String.format("Printing page %1$s of %2$s", e.getPageNumber(), e.getPageCount())));
activeSheet.getPageSetup().setCenterHeader("Page &P of &N");
workbook.save(outputStream, options);

// Close the file stream
try {
    outputStream.close();
} catch (IOException e) {
    e.printStackTrace();
}

// Create to a pdf file stream
FileOutputStream outputStream = null;
try {
    outputStream = new FileOutputStream("PagePrintEventsSkipPage.pdf");
} catch (FileNotFoundException e) {
    e.printStackTrace();
}
// Create a new workbook
Workbook workbook = new Workbook();
IWorksheet activeSheet = workbook.getActiveSheet();
activeSheet.getRange("A1").setValue(1);
activeSheet.getRange("A2:A100").setFormulaR1C1("=R[-1]C+1");
PdfSaveOptions options = new PdfSaveOptions();
options.getPagePrintingEvent().addListener((sender, e) -> {
if (e.getPageNumber() == 2) {
e.setSkipThisPage(true);
}
});
activeSheet.getPageSetup().setCenterHeader("Page &P of &N");
workbook.save(outputStream, options);

// Close the file stream
try {
    outputStream.close();
} catch (IOException e) {
    e.printStackTrace();
}

// Create to a pdf file stream
FileOutputStream outputStream = null;
try {
    outputStream = new FileOutputStream("PagePrintEventsExitPrinting.pdf");
} catch (FileNotFoundException e) {
    e.printStackTrace();
}
// Create a new workbook
Workbook workbook = new Workbook();
IWorksheet activeSheet = workbook.getActiveSheet();
activeSheet.getRange("A1").setValue(1);
activeSheet.getRange("A2:A100").setFormulaR1C1("=R[-1]C+1");
PdfSaveOptions options = new PdfSaveOptions();
options.getPagePrintedEvent().addListener((sender, e) -> {
if (e.getPageNumber() == 2) {
e.setHasMorePages(false);
}
});
activeSheet.getPageSetup().setCenterHeader("Page &P of &N");
workbook.save(outputStream, options);

// Close the file stream
try {
    outputStream.close();
} catch (IOException e) {
    e.printStackTrace();
}

Workbook workbook = new Workbook();
workbook.open("D:\\SampleTemplate.xlsx");
  
workbook.processTemplate();
  
PdfSaveOptions options = new PdfSaveOptions();
options.setOpenActionScript("var fld1 = this.getField(\"num\");" +
"fld1.value = fld1.value;" +
"this.dirty = false;");
  
workbook.save("SampleTemplate_java.pdf", options);

// Create a new workbook and add worksheets
Workbook workbook = new Workbook();
IWorksheet sheet1 = workbook.getWorksheets().get(0);
IWorksheet sheet2 = workbook.getWorksheets().add();

// Set style.
sheet1.getRange("A1").setValue("Sheet1");
sheet1.getRange("A1").getFont().setName("Wide Latin");
sheet1.getRange("A1").getFont().setColor(Color.GetRed());
sheet1.getRange("A1").getInterior().setColor(Color.GetGreen());

// Add Table
ITable table = sheet1.getTables().add(sheet1.getRange("C1:E5"), true);
sheet2.getRange("A1").setValue("Sheet2");

// Specify font path
Workbook.FontsFolderPath = "C:\\Users\\GPCTAdmin\\Documents\\Fonts";

// Get the used fonts list in workbook, the list are:"Wide Latin", "Calibri"
List<FontInfo> fonts = workbook.getUsedFonts();

// Save to a pdf file
workbook.save("configureFontsAndSetStyle.pdf", SaveFileFormat.Pdf);

// Just export sheet1 to pdf file.
sheet1.save("configureFontsAndSetStyle_sheet.pdf",SaveFileFormat.Pdf);

// Create a new workbook.
Workbook workbook = new Workbook();
IWorksheet sheet = workbook.getWorksheets().get(0);

// Set style of the font.
sheet.getRange("A1").setValue("Sheet1");
sheet.getRange("A1").getFont().setName("Arial");
sheet.getRange("A1").getFont().setColor(Color.GetRed());
sheet.getRange("A1").getInterior().setColor(Color.GetGreen());

// Implement FontProvider.
Workbook.FontProvider = new IFontProvider() {
    @Override
    public List<String> getFontFilePaths() {
        return new ArrayList<>(Arrays.asList(
                "fonts\\arial.ttf",
                "fonts\\arialbd.ttf",
                "fonts\\ariali.ttf"
        ));
    }

    @Override
    public InputStream getFont(String fontFilePath) {
        return getClass().getClassLoader().getResourceAsStream(fontFilePath);
    }
};

// Save the workbook.
workbook.save("FontStreaming.pdf", SaveFileFormat.Pdf);