// 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, 790, 120); //Set picture's transparency as 60%. picture.getPictureFormat().setTransparency(0.6); } catch (IOException e) { // Log ignored error of your code // log.debug(e.getMessage()); } // Save to an excel file workbook.save("PictureTransparency.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet: IWorksheet = workbook.getWorksheets().get(0) val stream = getResourceStream("logo.png") try { val picture: IShape = worksheet.shapes.addPicture(stream, ImageType.PNG, 20.0, 20.0, 790.0, 120.0) //Set picture's transparency as 60%. picture.pictureFormat.transparency = 0.6 } catch (e: IOException) { e.printStackTrace() } // Save to an excel file workbook.save("PictureTransparency.xlsx")