IXlPicture.Image Property

Gets or sets the image residing in the IXlPicture object.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v19.1.Core.dll

Declaration

C#

Image Image { get; set; }

VB.NET

Property Image As Image

Property Value

Type	Description
Image	A Image object.

Remarks

To display the desired image in a worksheet, assign it to the Image property. Use static methods of the Image object to create the image from the specified file or data stream (Image.FromFile or Image.FromStream).

The example below demonstrates how to use the IXlPicture.SetTwoCellAnchor method to anchor a picture to two cells in a worksheet. The starting anchor for a picture is located at the intersection of the second column (“B”) and the second row, with no offsets. The final anchor is located at the intersection of the seventh column (“G”) and the twelfth row, with offsets from both the column and row. The IXlPicture.AnchorBehavior is set to XlAnchorType.TwoCell, so that the picture moves and resizes with its underlying cells.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/xl-export-api-examples-t253492

PictureActions.cs

// Create a worksheet.
using (IXlSheet sheet = document.CreateSheet())
{

    // Insert a picture from a file and anchor it to cells. 
    using (IXlPicture picture = sheet.CreatePicture())
    {
        picture.Image = Image.FromFile(Path.Combine(imagesPath, "image1.jpg"));
        picture.SetTwoCellAnchor(new XlAnchorPoint(1, 1, 0, 0), new XlAnchorPoint(6, 11, 2, 15), XlAnchorType.TwoCell);
    }
}

PictureActions.vb

' Create a worksheet.
Using sheet As IXlSheet = document.CreateSheet()

    ' Insert a picture from a file and anchor it to cells. 
    Using picture As IXlPicture = sheet.CreatePicture()
        picture.Image = Image.FromFile(Path.Combine(imagesPath, "image1.jpg"))
        picture.SetTwoCellAnchor(New XlAnchorPoint(1, 1, 0, 0), New XlAnchorPoint(6, 11, 2, 15), XlAnchorType.TwoCell)
    End Using
End Using

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Image property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/PictureActions.cs#L38

{
    picture.Image = Image.FromFile(Path.Combine(imagesPath, "image1.jpg"));
    picture.SetTwoCellAnchor(new XlAnchorPoint(1, 1, 0, 0), new XlAnchorPoint(6, 11, 2, 15), XlAnchorType.TwoCell);

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/PictureActions.vb#L35

Using picture As IXlPicture = sheet.CreatePicture()
    picture.Image = Image.FromFile(Path.Combine(imagesPath, "image1.jpg"))
    picture.SetTwoCellAnchor(New XlAnchorPoint(1, 1, 0, 0), New XlAnchorPoint(6, 11, 2, 15), XlAnchorType.TwoCell)