Worksheet.Pictures Property

Provides access to a collection of pictures in a worksheet.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

PictureCollection Pictures { get; }

VB.NET

ReadOnly Property Pictures As PictureCollection

Property Value

Type	Description
PictureCollection	A PictureCollection object that contains all the pictures in a worksheet.

Remarks

Use the PictureCollection.AddPicture method, accessible using the Worksheet.Pictures.AddPictures notation, to create a new picture and add it to a worksheet.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Pictures 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#

spreadsheet-document-api-use-worksheet-table-as-data-source/CS/SpreadsheetDocumentServerAsDataSourceExample/MyPictureProvider.cs#L32

Dictionary<string, Bitmap> employeePictures = new Dictionary<string, System.Drawing.Bitmap>();
foreach (Picture pic in sheet.Pictures) {
    employeePictures.Add(pic.Name, new Bitmap(new MemoryStream(pic.Image.GetImageBytes(OfficeImageFormat.Bmp))));

VB.NET

spreadsheet-document-api-use-worksheet-table-as-data-source/VB/SpreadsheetDocumentServerAsDataSourceExample/MyPictureProvider.vb#L35

Dim employeePictures As Dictionary(Of String, Bitmap) = New Dictionary(Of String, System.Drawing.Bitmap)()
For Each pic As Picture In sheet.Pictures
    employeePictures.Add(pic.Name, New Bitmap(New MemoryStream(pic.Image.GetImageBytes(OfficeImageFormat.Bmp))))