//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, picture's range is Range("A2:I6") IShape picture = worksheet.getShapes().addPicture(stream, ImageType.PNG, 20, 20, 395, 60); //Range("A2:I6") must contain picture's range, copy a new picture to Range("J2:R6") worksheet.getRange("A2:I6").copy(worksheet.getRange("J2")); //worksheet.getRange("A2:I6").copy(worksheet.getRange("J2:R6")); //Cross sheet copy, copy a new shape to worksheet2's Range("J2:R6") //IWorksheet worksheet2 = workbook.getWorksheets().add(); //worksheet.getRange("A2:I6").copy(worksheet2.getRange("J2")); //worksheet.getRange("A2:I6").copy(worksheet2.getRange("J2:R6")); } catch (IOException e) { e.printStackTrace(); } //save to an excel file workbook.save("PictureCopy.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, picture's range is Range("A2:I6") val picture = worksheet.shapes.addPicture(stream, ImageType.PNG, 20.0, 20.0, 395.0, 60.0) //Range("A2:I6") must contain picture's range, copy a new picture to Range("J2:R6") worksheet.getRange("A2:I6").copy(worksheet.getRange("J2")) //worksheet.getRange("A2:I6").copy(worksheet.getRange("J2:R6")); //Cross sheet copy, copy a new shape to worksheet2's Range("J2:R6") //IWorksheet worksheet2 = workbook.getWorksheets().add(); //worksheet.getRange("A2:I6").copy(worksheet2.getRange("J2")); //worksheet.getRange("A2:I6").copy(worksheet2.getRange("J2:R6")); } catch (e: IOException) { e.printStackTrace() } //save to an excel file workbook.save("PictureCopy.xlsx")