// 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(); }
// Create a Image file stream FileOutputStream("SetGridlineAndBackgroundColor.png").use { val outputStream = it // Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets[0] worksheet.getRange("A1").value = "Sales Report" worksheet.getRange("A1").font.color = Color.FromArgb(56, 93, 171) worksheet.getRange("A1").font.size = 24.0 worksheet.getRange("A1").font.bold = true worksheet.getRange("A3:E13").value = arrayOf( arrayOf("Date", "Product", "Customer", "Amount", "Show"), arrayOf(LocalDate.of(2021, 1, 1), "Bose 785593-0050", "Fabrikam, Inc.", 1886.00, 1), arrayOf(LocalDate.of(2021, 1, 3), "Canon EOS 1500D", "Alpine Ski House", 4022.00, null), arrayOf(LocalDate.of(2021, 1, 4), "Haier 394L 4Star", "Coho Winery", 8144.00, null), arrayOf(LocalDate.of(2021, 1, 7), "IFB 6.5 Kg FullyAuto", "Southridge Video", 8002.00, 1), arrayOf(LocalDate.of(2021, 1, 11), "Mi LED 40inch", "Coho Winery", 6392.00, null), arrayOf(LocalDate.of(2021, 1, 25), "Sennheiser HD 4.40-BT", "Contoso, Ltd", 6444.00, 1), arrayOf(LocalDate.of(2021, 1, 30), "Iphone XR", "Southridge Video", 2772.00, null), arrayOf(LocalDate.of(2021, 2, 4), "OnePlus 7Pro", "City Power & Light", 8674.00, 1), arrayOf(LocalDate.of(2021, 2, 5), "Redmi 7", "A. Datum Corporation", 2332.00, null), arrayOf(LocalDate.of(2021, 2, 8), "Samsung S9", "Alpine Ski House", 5370.00, 1) ) worksheet.getRange("D4:D13").numberFormat = "$0.00" worksheet.getRange("A3:E13").font.color = Color.FromArgb(56, 93, 171) worksheet.getRange("A3:E3").font.bold = true worksheet.usedRange.autoFit() val options = ImageSaveOptions() // Set the background color of the exported image options.backgroundColor = Color.FromArgb(226, 231, 243) // Set the gridlines of the exported image options.showGridlines = true options.gridlineColor = Color.FromArgb(145, 167, 214) worksheet.toImage(outputStream, ImageType.PNG, options) // End using the file stream }