//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); InputStream stream = this.getResourceStream("logo.png"); try { IShape picture = worksheet.getShapes().addPicture(stream, ImageType.PNG, 20, 20, 100, 100); //set picture size. picture.setWidthInPixel(700); picture.setHeightInPixel(120); //config picture layout. picture.getFill().solid(); picture.getFill().getColor().setObjectThemeColor(ThemeColor.Accent1); //delete picture. picture.delete(); } catch (IOException e) { e.printStackTrace(); } //save to an excel file workbook.save("DeletePicture.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val stream = this.getResourceStream("logo.png") try { val picture = worksheet.shapes.addPicture(stream, ImageType.PNG, 20.0, 20.0, 100.0, 100.0) //set picture size. picture.widthInPixel = 700.0 picture.heightInPixel = 120.0 //config picture layout. picture.fill.solid() picture.fill.color.objectThemeColor = ThemeColor.Accent1 //delete picture. picture.delete() } catch (e: IOException) { e.printStackTrace() } //save to an excel file workbook.save("DeletePicture.xlsx")