Show / Hide Table of Contents

Shape Fills

Output: ShapesFill.xlsx

public void Run()
{
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets[0];

    worksheet.Columns["A"].WidthPixels = 150;
    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.Fill.SolidOfficeColor = DrawingColor.Red;

    var rectangle2 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B2", cellOffsetPixel, size);
    rectangle2.Fill.SolidOfficeColor = DrawingColor.Red;
    rectangle2.Fill.Transparency = 0.5m;

    var rectangle3 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B3", cellOffsetPixel, size);
    rectangle3.Fill.Gradient = new GradientFill();
    rectangle3.Fill.Gradient.GradientStops.Add(new Spreadsheet.Office.Drawing.GradientStop(0, DrawingColor.Text1));
    rectangle3.Fill.Gradient.GradientStops.Add(new Spreadsheet.Office.Drawing.GradientStop(0.5m, DrawingColor.Yellow));
    rectangle3.Fill.Gradient.GradientStops.Add(new Spreadsheet.Office.Drawing.GradientStop(1, DrawingColor.Red));

    var rectangle4 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B4", cellOffsetPixel, size);
    rectangle4.Fill.Gradient = GradientPresets.Horizon();

    var rectangle5 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B5", cellOffsetPixel, size);
    rectangle5.Fill.Type = FillType.PatternFill;
    rectangle5.Fill.Pattern.Preset = PatternType.DiagonalBrick;
    rectangle5.Fill.Pattern.BackgroundColor = DrawingColor.Background;
    rectangle5.Fill.Pattern.ForegroundColor = DrawingColor.Red;

    workbook.SaveAs("ShapesFill.xlsx");
}
Back to top Generated by DocFX