// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShapes shapes = worksheet.getShapes(); IShape rectangle = shapes.addShape(AutoShapeType.Rectangle, 20, 20, 100, 100); rectangle.getFill().getColor().setRGB(Color.FromArgb(169, 209, 142)); IShape oval = shapes.addShape(AutoShapeType.Oval, 50, 50, 100, 100); oval.getFill().getColor().setRGB(Color.FromArgb(157, 195, 230)); IShape triangle = shapes.addShape(AutoShapeType.IsoscelesTriangle, 80, 80, 100, 100); triangle.getFill().getColor().setRGB(Color.FromArgb(255, 230, 153)); // Set rectangle above oval rectangle.zOrder(ZOrderType.BringForward); // Set triangle to bottom triangle.zOrder(ZOrderType.SendToBack); // Save to an excel file workbook.save("SetShapeZOrder.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shapes = worksheet.shapes val rectangle = shapes.addShape(AutoShapeType.Rectangle, 20.0, 20.0, 100.0, 100.0) rectangle.fill.color.rgb = Color.FromArgb(169, 209, 142) val oval = shapes.addShape(AutoShapeType.Oval, 50.0, 50.0, 100.0, 100.0) oval.fill.color.rgb = Color.FromArgb(157, 195, 230) val triangle = shapes.addShape(AutoShapeType.IsoscelesTriangle, 80.0, 80.0, 100.0, 100.0) triangle.fill.color.rgb = Color.FromArgb(255, 230, 153) // Set rectangle above oval rectangle.zOrder(ZOrderType.BringForward) // Set triangle to bottom triangle.zOrder(ZOrderType.SendToBack) // Save to an excel file workbook.save("SetShapeZOrder.xlsx")