Shape Line Formatting
Output: ShapesLine.xlsx
public void Run()
{
var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];
worksheet.Columns["B"].WidthPixels = 90;
worksheet.GetRange("A1:A10").SetRowsHeight(53);
Position cellOffsetPixel = new Position(5, 5, ScreenMeasurementUnit.Pixel);
Size size = new Size(738000, 428625, ScreenMeasurementUnit.Emu);
var rectangle1 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B1", cellOffsetPixel, size);
rectangle1.Line.OfficeColor = DrawingColor.Red;
rectangle1.Line.WidthPoints = 2;
var rectangle2 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B2", cellOffsetPixel, size);
rectangle2.Line.OfficeColor = DrawingColor.Red;
rectangle2.Line.WidthPoints = 2;
rectangle2.Line.Transparency = 0.5m;
var rectangle3 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B3", cellOffsetPixel, size);
rectangle3.Line.Gradient = new GradientFill();
rectangle3.Line.Gradient.GradientStops.Add(new Spreadsheet.Office.Drawing.GradientStop(0, DrawingColor.Text1));
rectangle3.Line.Gradient.GradientStops.Add(new Spreadsheet.Office.Drawing.GradientStop(1, DrawingColor.Red));
rectangle3.Line.WidthPoints = 2;
var rectangle4 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B4", cellOffsetPixel, size);
rectangle4.Line.OfficeColor = DrawingColor.Text1;
rectangle4.Line.WidthPoints = 5;
rectangle4.Line.CompoundType = CompoundLine.Triple;
workbook.SaveAs("ShapesLine.xlsx");
}