//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); InputStream stream = this.getResourceStream("logo.png"); try { //Create a shape in worksheet IShape picture = worksheet.getShapes().addPicture(stream, ImageType.PNG, 20, 20, 395, 60); //Duplicate picture IShape newPicture = picture.duplicate(); } catch (IOException e) { e.printStackTrace(); } //save to an excel file workbook.save("PictureDuplicate.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val stream = this.getResourceStream("logo.png") try { //Create a shape in worksheet val picture = worksheet.shapes.addPicture(stream, ImageType.PNG, 20.0, 20.0, 395.0, 60.0) //Duplicate picture val newPicture = picture.duplicate() } catch (e: IOException) { e.printStackTrace() } //save to an excel file workbook.save("PictureDuplicate.xlsx")