// Create a png file stream FileOutputStream outputStream = null; try { outputStream = new FileOutputStream("ConvertRangeToImage.png"); } catch (FileNotFoundException e) { e.printStackTrace(); } // Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:C1").setValue(new String[] { "Device", "Quantity", "Unit Price" }); worksheet.getRange("A2:C5").setValue(new Object[][] { { "T540p", 12, 9850 }, { "T570", 5, 7460 }, { "Y460", 6, 5400 }, { "Y460F", 8, 6240 } }); // Set style worksheet.getRange("A1:C1").getFont().setBold(true); worksheet.getRange("A1:C1").getFont().setColor(Color.GetWhite()); worksheet.getRange("A1:C1").getInterior().setColor(Color.GetLightBlue()); worksheet.getRange("A2:C5").getBorders().get(BordersIndex.InsideHorizontal).setColor(Color.GetOrange()); worksheet.getRange("A2:C5").getBorders().get(BordersIndex.InsideHorizontal).setLineStyle(BorderLineStyle.DashDot); // Save the range "A1:C5" as an image to a stream. worksheet.getRange("A1:C5").toImage(outputStream, ImageType.PNG); // Close the file stream try { outputStream.close(); } catch (IOException e) { e.printStackTrace(); }
// Create a Image file stream FileOutputStream("ConvertRangeToImage.png").use { val outputStream = it // Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1:C1").value = arrayOf("Device", "Quantity", "Unit Price") worksheet.getRange("A2:C5").value = arrayOf(arrayOf("T540p", 12, 9850), arrayOf("T570", 5, 7460), arrayOf("Y460", 6, 5400), arrayOf("Y460F", 8, 6240)) // Set style worksheet.getRange("A1:C1").font.bold = true worksheet.getRange("A1:C1").font.color = Color.GetWhite() worksheet.getRange("A1:C1").interior.color = Color.GetLightBlue() worksheet.getRange("A2:C5").borders.get(BordersIndex.InsideHorizontal).color = Color.GetOrange() worksheet.getRange("A2:C5").borders.get(BordersIndex.InsideHorizontal).lineStyle = BorderLineStyle.DashDot // Save the range "A1:C5" as an image to a stream. worksheet.getRange("A1:C5").toImage(outputStream, ImageType.PNG) // End using the file stream }