//create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet = workbook.getWorksheets().get(0); //Set text. sheet.getRange("A1:G10").setValue("Text"); //Add picture in sheet. InputStream stream = this.getResourceStream("logo.png"); IShape picture = null; try { picture = sheet.getShapes().addPicture(stream, ImageType.PNG, 20, 20, 395, 60); } catch (IOException ioe) { } //Add header graphic. InputStream stream1 = this.getResourceStream("logo.png"); sheet.getPageSetup().setCenterHeader("&G"); sheet.getPageSetup().getCenterHeaderPicture().setGraphicStream(stream1, ImageType.PNG); sheet.getPageSetup().getCenterHeaderPicture().setWidth(100); sheet.getPageSetup().getCenterHeaderPicture().setHeight(13); //Set print without graphics in page content area. sheet.getPageSetup().setDraft(true); //save to an pdf file workbook.save("ConfigureDraft.pdf");
//create a new workbook var workbook = Workbook() val sheet = workbook.worksheets.get(0) //Set text. sheet.getRange("A1:G10").value = "Text" //Add picture in sheet. val stream = this.getResourceStream("logo.png") var picture: IShape? = null try { picture = sheet.shapes.addPicture(stream, ImageType.PNG, 20.0, 20.0, 395.0, 60.0) } catch (ioe: IOException) { } //Add header graphic. val stream1 = this.getResourceStream("logo.png") sheet.pageSetup.centerHeader = "&G" sheet.pageSetup.centerHeaderPicture.setGraphicStream(stream1, ImageType.PNG) sheet.pageSetup.centerHeaderPicture.width = 100.0 sheet.pageSetup.centerHeaderPicture.height = 13.0 //Set print without graphics in page content area. sheet.pageSetup.draft = true //save to an pdf file workbook.save("ConfigureDraft.pdf")