// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); InputStream stream = this.getResourceStream("AcmeLogo.png"); try { //Add background picture IBackgroundPicture picture = worksheet.getBackgroundPictures().addPictureInPixel(stream, ImageType.PNG, 10, 10, 500, 370); //Set image layout picture.setBackgroundImageLayout(ImageLayout.Zoom); } catch (IOException e) { // Log ignored error of your code // log.debug(e.getMessage()); } //Set options workbook.getActiveSheet().getPageSetup().setPrintGridlines(true); // Save to a pdf file workbook.save("BackgroundImage.pdf");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val stream = this.getResourceStream("AcmeLogo.png") try { //Add background picture val picture = worksheet.getBackgroundPictures().addPictureInPixel(stream, ImageType.PNG, 10.0, 10.0, 500.0, 370.0) //Set image layout picture.setBackgroundImageLayout(ImageLayout.Zoom) } catch (e: IOException) { // TODO Auto-generated catch block e.printStackTrace() } //Set options workbook.activeSheet.pageSetup.printGridlines = true // Save to a pdf file workbook.save("BackgroundImage.pdf")