ImageInfo Interface

Exposes members used to specify information about an image placed in a cell.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public interface ImageInfo

VB.NET

Public Interface ImageInfo

Related API Members

The following members return ImageInfo objects:

• Cell.ImageInfo

Example

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

C#

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

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

    // 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.NET

Private Sub New(Optional ByVal workbook As New Workbook())
    Dim worksheet As Worksheet = workbook.Worksheets.ActiveWorksheet

    Dim imageStream As New MemoryStream(imageBytes)

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


    ' 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 Sub