// 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");