Show / Hide Table of Contents

Ole Embed Workbook as Icon

Output: OleEmbedIcon.xlsx

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

    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.Effects.Shadow.Type = ShadowType.Outer;
    rectangle1.Effects.Shadow.Color = DrawingColor.Black;
    rectangle1.Effects.Shadow.Transparency = 0.4m;
    rectangle1.Effects.Shadow.Size = 1.2m;
    rectangle1.Effects.Shadow.Blur = 4;
    rectangle1.Effects.Shadow.Angle = 45;
    rectangle1.Effects.Shadow.Distance = 6;

    var rectangle2 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B2", cellOffsetPixel, size);
    rectangle2.Effects.Shadow.Type = ShadowType.Outer;
    rectangle2.Effects.Shadow.Color = DrawingColor.Red;
    rectangle2.Effects.Shadow.Transparency = 0.2m;
    rectangle2.Effects.Shadow.Size = 1;
    rectangle2.Effects.Shadow.Blur = 4;
    rectangle2.Effects.Shadow.Angle = 45;
    rectangle2.Effects.Shadow.Distance = 6;

    var rectangle3 = worksheet.Shapes.AddShape(ShapeType.Rectangle, "B3", cellOffsetPixel, size);
    rectangle3.Fill.SolidOfficeColor = DrawingColor.Window;
    rectangle3.Effects.Shadow.Type = ShadowType.Inner;
    rectangle3.Effects.Shadow.Color = DrawingColor.Black;
    rectangle3.Effects.Shadow.Transparency = 0.4m;
    rectangle3.Effects.Shadow.Blur = 5;
    rectangle3.Effects.Shadow.Angle = 135;
    rectangle3.Effects.Shadow.Distance = 6;

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