// Create a png file stream FileOutputStream outputStream = null; try { outputStream = new FileOutputStream("SetGridlineAndBackgroundColor.png"); } catch (FileNotFoundException e) { e.printStackTrace(); } // Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1").setValue("Sales Report"); worksheet.getRange("A1").getFont().setColor(Color.FromArgb(56, 93, 171)); worksheet.getRange("A1").getFont().setSize(24); worksheet.getRange("A1").getFont().setBold(true); worksheet.getRange("A3:E13").setValue(new Object[][] { {"Date", "Product", "Customer", "Amount", "Show"}, {LocalDate.of(2021, 1, 1), "Bose 785593-0050", "Fabrikam, Inc.", 1886.00, 1}, {LocalDate.of(2021, 1, 3), "Canon EOS 1500D", "Alpine Ski House", 4022.00, null}, {LocalDate.of(2021, 1, 4), "Haier 394L 4Star", "Coho Winery", 8144.00, null}, {LocalDate.of(2021, 1, 7), "IFB 6.5 Kg FullyAuto", "Southridge Video", 8002.00, 1}, {LocalDate.of(2021, 1, 11), "Mi LED 40inch", "Coho Winery", 6392.00, null}, {LocalDate.of(2021, 1, 25), "Sennheiser HD 4.40-BT", "Contoso, Ltd", 6444.00, 1}, {LocalDate.of(2021, 1, 30), "Iphone XR", "Southridge Video", 2772.00, null}, {LocalDate.of(2021, 2, 4), "OnePlus 7Pro", "City Power & Light", 8674.00, 1}, {LocalDate.of(2021, 2, 5), "Redmi 7", "A. Datum Corporation", 2332.00, null}, {LocalDate.of(2021, 2, 8), "Samsung S9", "Alpine Ski House", 5370.00, 1} }); worksheet.getRange("D4:D13").setNumberFormat("$0.00"); worksheet.getRange("A3:E13").getFont().setColor(Color.FromArgb(56, 93, 171)); worksheet.getRange("A3:E3").getFont().setBold(true); worksheet.getUsedRange().autoFit(); ImageSaveOptions options = new ImageSaveOptions(); // Set the background color of the exported image options.setBackgroundColor(Color.FromArgb(226, 231, 243)); // Set the gridlines of the exported image options.setShowGridlines(true); options.setGridlineColor(Color.FromArgb(145, 167, 214)); worksheet.toImage(outputStream, ImageType.PNG, options); // Close the file stream try { outputStream.close(); } catch (IOException e) { e.printStackTrace(); }