Pictures
EPPlus supports adding pictures/images from a file, a stream or via an image object.
Pictures are added to worksheets via the AddPicture method, which is accessed via the Drawings property on ExcelWorksheet. This method has many overloads and returns an ExcelPicture instance. Via the properties of ExcelPicture you can set properties like size, border, fill and other effects.
The ExcelPicture class also has an Image property that represents the actual image. See the ExcelImage class below.
Adding a picture/image to the workbook will work in a very similar way as adding a Shape
//Add a jpg image and apply some effects (EPPlus 6+ interface).
var pic = worksheet.Drawings.AddPicture("Landscape", new FileInfo("c:\\temp\\LandscapeView.jpg"));
pic.SetPosition(2, 0, 1, 0);
pic.Effect.SetPresetShadow(ePresetExcelShadowType.OuterBottomRight);
pic.Effect.OuterShadow.Distance = 10;
pic.Effect.SetPresetSoftEdges(ePresetExcelSoftEdgesType.SoftEdge5Pt);
From EPPlus 6, the ExcelImage class replaces all System.Drawing.Common.Image properties (see list above).
These properties are all readonly.
| Name | Data type | Description |
|---|---|---|
ImageBytes |
byte[] |
The image as a byte-array |
Type |
ePictureType |
The type of image, for example jpg, gif or svg |
Bounds |
ExcelImageInfo |
The bounds and resolution of the image |
| Name | Description |
|---|---|
SetImage(string) |
Sets the image from a file path |
SetImage(FileInfo) |
Sets the image from a FileInfo object |
SetImage(byte[], ePictureType) |
Sets the image from a byte array |
SetImage(Stream, ePictureType) |
Sets the image from a stream |
SetImage(ExcelImage) |
Sets the image from another image object |
SetImageAsync(string) |
Sets the image from a file path |
SetImageAsync(FileInfo) |
Sets the image from a FileInfo object |
SetImageAsync(Stream, ePictureType) |
Sets the image from a stream |