// Create a new workbook Workbook workbook = new Workbook(); //Use sheet index to get worksheet. IWorksheet worksheet = workbook.getWorksheets().get(0); InputStream inputStream = this.getResourceStream("angle.png"); try { byte[] bytes = new byte[inputStream.available()]; inputStream.read(bytes, 0, bytes.length); worksheet.setBackgroundPicture(bytes); }catch (IOException ioe){ // Log ignored error of your code // log.debug(ioe.getMessage()); } // Save to an excel file workbook.save("SetBackgroundImage.xlsx");
// Create a new workbook var workbook = Workbook() //Use sheet index to get worksheet. val worksheet = workbook.worksheets.get(0) val inputStream = this.getResourceStream("angle.png") inputStream?.use { stream -> val bytes = stream.readBytes() worksheet.backgroundPicture = bytes } // Save to an excel file workbook.save("SetBackgroundImage.xlsx")