//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addShape(AutoShapeType.Parallelogram, 1, 1, 200, 100); shape.getLine().setDashStyle(LineDashStyle.Dash); shape.getLine().setStyle(LineStyle.Single); shape.getLine().setWeight(2); shape.getLine().getColor().setObjectThemeColor(ThemeColor.Accent6); shape.getLine().setTransparency(0.3); //save to an excel file workbook.save("ConfigShapeLine.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addShape(AutoShapeType.Parallelogram, 1.0, 1.0, 200.0, 100.0) shape.line.dashStyle = LineDashStyle.Dash shape.line.style = LineStyle.Single shape.line.weight = 2.0 shape.line.color.objectThemeColor = ThemeColor.Accent6 shape.line.transparency = 0.3 //save to an excel file workbook.save("ConfigShapeLine.xlsx")