//create a new workbook Workbook workbook = new Workbook(); // Open an excel file InputStream fileStream = this.getResourceStream("xlsx/Sport sign-up sheet.xlsx"); workbook.open(fileStream); IWorksheet worksheet = workbook.getWorksheets().get(0); // Get the absolute location and size of the Range["G1"] in the worksheet. IRange range = worksheet.getRange("G1"); Rectangle rect = com.grapecity.documents.excel.CellInfo.GetRangeBoundary(range); // Add the image to the Range["G1"] InputStream stream = this.getResourceStream("logo.png"); try { worksheet.getShapes().addPictureInPixel(stream, ImageType.PNG, rect.getX(), rect.getY(), rect.getWidth(), rect.getHeight()); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } //save to an excel file workbook.save("GetRangeBoundary.xlsx");
//create a new workbook var workbook = Workbook() // Open an excel file val fileStream = this.getResourceStream("xlsx/Sport sign-up sheet.xlsx") workbook.open(fileStream) val worksheet = workbook.getWorksheets().get(0) // Get the absolute location and size of the Range["G1"] in the worksheet. val range = worksheet.getRange("G1") val rect = com.grapecity.documents.excel.CellInfo.GetRangeBoundary(range) // Add the image to the Range["G1"] val stream = this.getResourceStream("logo.png") try { worksheet.getShapes().addPictureInPixel(stream, ImageType.PNG, rect.getX(), rect.getY(), rect.getWidth(), rect.getHeight()) } catch (e: IOException) { // TODO Auto-generated catch block e.printStackTrace() } //save to an excel file workbook.save("GetRangeBoundary.xlsx")