Export Fills

DsExcel Java allows users to save worksheets possessing cells with different fill styles.

In order to export an excel file with fills to PDF format, refer to the following example code.

// Create a new workbook and access the default worksheet
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().get(0);
        
// Merge cells and apply fill style
worksheet.getRange("A1:C2").merge();
worksheet.getRange("A1:C2").getInterior().setColor(Color.GetGreen());

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