// Create a new workbook Workbook workbook = new Workbook(); InputStream fileStream = this.getResourceStream("xlsx/ShapeType.xlsx"); workbook.open(fileStream); IWorksheet sheet = workbook.getWorksheets().get(0); int row = 2; int column = 4; for (int i = 0; i < sheet.getShapes().getCount(); i++) { IShape shape = sheet.getShapes().get(i); // Add a text on the right side of the shape to display the type of the shape. sheet.getRange(row, column).setValue("This is a " + shape.getType().toString() + "."); sheet.getRange(row, column).getFont().setBold(true); sheet.getRange(row, column).getFont().setSize(13); // Row and column change every 4 shapes. if ((i + 1) % 4 == 0) { row = 2; column += 6; } else { row += 10; } } // Save to an excel file workbook.save("GetShapeType.xlsx");