//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; GrapeCity.Documents.Excel.Drawing.IShape shape = worksheet.Shapes.AddShape(GrapeCity.Documents.Excel.Drawing.AutoShapeType.Parallelogram, 1, 1, 200, 100); shape.Line.DashStyle = GrapeCity.Documents.Excel.Drawing.LineDashStyle.Dash; shape.Line.Style = GrapeCity.Documents.Excel.Drawing.LineStyle.Single; shape.Line.Weight = 2; shape.Line.Color.ObjectThemeColor = ThemeColor.Accent6; shape.Line.Transparency = 0.3; // Save to an excel file workbook.Save("ConfigShapeLine.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) Dim shape As IShape = worksheet.Shapes.AddShape(AutoShapeType.Parallelogram, 1, 1, 200, 100) shape.Line.DashStyle = LineDashStyle.Dash shape.Line.Style = LineStyle.Single shape.Line.Weight = 2 shape.Line.Color.ObjectThemeColor = ThemeColor.Accent6 shape.Line.Transparency = 0.3 ' save to an excel file workbook.Save("ConfigShapeLine.xlsx")