How To Add Pictures Or Images In Excel Sheet Using EPPlus .NET Application (C#) - Part Five

First, we need to add two namespaces:

• using System.Drawing;
• using OfficeOpenXml.Drawing;

• Image img = Image.FromFile(@"D:\sample.png");

Here, ExcelPicture is seal class and it is inherited from ExcelDrawing class. Here, Drawings property is the type of ExcelDrawings class and assigns a property of ExcelSheet class object wsSheet1.

In the next line, if we go to the definition of ExcelPicture class, as we can see - it has no SetPosition(RowIndex - 1, 0, ColIndex - 1, 5) method. This method is given from parent class ExcelDrawing.

Here, SetPosition() is two overloaded versions. We have already seen the first overload method; it accepts SetPosition(int RowIndex, int RowOffsetPixels, int ColIndex, int ColumnOffsetPixels) & second overload is SetPosition(PixelTop, PixelLeft), both parameters are int type. PixelTop count the pixel from top & PixelLeft count the pixel from the left size of your computer screen.

For Example

• ExcelPicture pic = wsSheet1.Drawings.AddPicture("Picture_Name", img);
• int PixelTop = 88;
• int PixelLeft = 129;
• pic.SetPosition(PixelTop, PixelLeft);

At the end, ExcelPicture has own method SetSize(int Width, int Height) & SetSize(int percent) (two overloaded versions). It can accept picture width & height as integer type parameter & second overload method accepts overall original picture width & height in percentage.

Note

Resizing columns and rows after using SetSize(int percent) function will affect the size of picture.

For example -

• int Width = 320;
• int Height= 200;
• pic.SetSize(Width, Height);
• pic.SetSize(40);

Output in Excel sheet will look like below.