// 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");
// Create a new workbook var workbook = Workbook() workbook.open(getResourceStream("xlsx/ShapeType.xlsx")) val sheet = workbook.worksheets[0] var row = 2 var column = 4 for (i in 0 until sheet.shapes.count) { val shape = sheet.shapes[i] // Add a text on the right side of the shape to display the type of the shape. sheet.getRange(row, column).value = "This is a " + shape.type.toString() + "." sheet.getRange(row, column).font.bold = true sheet.getRange(row, column).font.size = 13.0 // 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")