//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); // Create a PrintManager. PrintManager printManager = new PrintManager(); // Get the size of the printArea. Size size = printManager.getSize(worksheet.getRange("A1:C5")); PDRectangle pageSize = new PDRectangle((float) size.getWidth(), (float) size.getHeight()); // Create a pdf document. PDDocument doc = new PDDocument(); PDPage page = new PDPage(pageSize); doc.addPage(page); // Draw the Range"A1:C5" to the specified location on the page. printManager.draw(doc, page, new Point(0, 0), worksheet.getRange("A1:C5")); // Saves the page as an image to a stream. PDFRenderer pdfRenderer = new PDFRenderer(doc); BufferedImage bim; try { bim = pdfRenderer.renderImage(0); ImageIO.write(bim, "PNG", outputStream); doc.close(); } catch (IOException e) { e.printStackTrace(); } //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 // Create a PrintManager. val printManager = PrintManager() // Get the size of the printArea. val size = printManager.getSize(worksheet.getRange("A1:C5")) val pageSize = PDRectangle(size.width.toFloat(), size.height.toFloat()) // Create a pdf document. val doc = PDDocument() val page = PDPage(pageSize) doc.addPage(page) // Draw the Range"A1:C5" to the specified location on the page. printManager.draw(doc, page, Point(0.0, 0.0), worksheet.getRange("A1:C5")) // Saves the page as an image to a stream. val pdfRenderer = PDFRenderer(doc) val bim: BufferedImage try { bim = pdfRenderer.renderImage(0) ImageIO.write(bim, "PNG", outputStream) doc.close() } catch (e: IOException) { e.printStackTrace() } //close the file stream try { if(outputStream != null){ outputStream.close() } } catch (e: IOException) { e.printStackTrace() }