Back to Devexpress

Cell.ImageInfo Property

officefileapi-devexpress-dot-spreadsheet-dot-cell-5baa4d51.md

latest2.2 KB
Original Source

Cell.ImageInfo Property

Obtains information about an image embedded in the cell.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
ImageInfo ImageInfo { get; }
vb
ReadOnly Property ImageInfo As ImageInfo

Property Value

TypeDescription
ImageInfo

An object that contains cell image information.

|

Example

The following code snippet places an image from a stream in a cell and specifies its alternative text:

csharp
using (Workbook workbook = new Workbook()) {
    Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;

    byte[] imageBytes = File.ReadAllBytes("image.png");

    // Insert cell images from a stream
    worksheet.Cells["A2"].Value = imageStream;

    // Specify image information
    if (worksheet.Cells["A2"].Value.IsCellImage) {
        worksheet.Cells["A2"].ImageInfo.Decorative = true;
        worksheet.Cells["A2"].ImageInfo.AlternativeText = "Image AltText";
    }

    workbook.SaveDocument("result.xlsx");
}
vb
Using Optional ByVal workbook As New Workbook()
    Dim worksheet As Worksheet = workbook.Worksheets.ActiveWorksheet

    Dim imageBytes() As Byte = File.ReadAllBytes("image.png")

    ' Insert cell images from a stream
    worksheet.Cells("A2").Value = imageBytes()

    ' Specify image information
    If worksheet.Cells("A2").Value.IsCellImage Then
       worksheet.Cells("A2").ImageInfo.Decorative = True
       worksheet.Cells("A2").ImageInfo.AlternativeText = "Image AltText"
    End If

    workbook.SaveDocument("result.xlsx")
End Using

See Also

Cell Interface

Cell Members

DevExpress.Spreadsheet Namespace