Show / Hide Table of Contents

Ole Embed Workbook as Icon

Output: Pictures.xlsx

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

    worksheet.Columns["A"].WidthPixels = 120;
    worksheet.Columns["B"].WidthPixels = 90;
    worksheet.GetRange("A1:A5").SetRowsHeight(60);



    var picture1 = worksheet.Shapes.AddPicture("smiley.png", "B1",
    new Position(5, 5, ScreenMeasurementUnit.Pixel), new Size(0.75, 0.75, ScreenMeasurementUnit.Inch));
            
    var picture2 = worksheet.Shapes.AddPicture("smiley.png", "B2",
    new Position(5, 5, ScreenMeasurementUnit.Pixel), new Size(0.75, 0.75, ScreenMeasurementUnit.Inch));
    picture2.Picture.BrightnessCorrection = -0.5m;

    var picture3 = worksheet.Shapes.AddPicture("smiley.png", "B3",
    new Position(5, 5, ScreenMeasurementUnit.Pixel), new Size(0.75, 0.75, ScreenMeasurementUnit.Inch));
            picture3.Picture.ContrastCorrection = 0.8m;

    var picture4 = worksheet.Shapes.AddPicture("smiley.png", "B4",
    new Position(5, 5, ScreenMeasurementUnit.Pixel), new Size(0.75, 0.75, ScreenMeasurementUnit.Inch));
    picture4.Picture.Recolor = Recolor.Sepia;

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