//create to 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 to a png file stream var outputStream: FileOutputStream? = null try { outputStream = FileOutputStream("ConvertRangeToImage.png") } catch (e: FileNotFoundException) { e.printStackTrace() } //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) //close the file stream try { if(outputStream != null){ outputStream.close() } } catch (e: IOException) { e.printStackTrace() }