.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PictureCollection.AddPicture(SpreadsheetImageSource, Single, Single, Single, Single) Method

Inserts a picture from the SpreadsheetImageSource object at the specified location and resize it to the specified dimensions.

Namespace: DevExpress.Spreadsheet

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

Declaration

Picture AddPicture(
    SpreadsheetImageSource imageSource,
    float x,
    float y,
    float width,
    float height
)

Parameters

Name Type Description
imageSource SpreadsheetImageSource

A SpreadsheetImageSource object containing an image to insert.

x Single

A Single value that is the distance from the left of the worksheet. The ISpreadsheetComponent.Unit property specifies the unit of measurement.

y Single

A Single value that is the distance from the top of the worksheet. The ISpreadsheetComponent.Unit property specifies the unit of measurement.

width Single

A Single value that is the desired width of the picture. The ISpreadsheetComponent.Unit property specifies the unit of measurement.

height Single

A Single value that is the desired height of the picture. The ISpreadsheetComponent.Unit property specifies the unit of measurement.

Returns

Type Description
Picture

A Picture object that is the inserted picture.

Remarks

The SpreadsheetImageSource object enables you to create a picture from various sources - from a stream, a file, or from a Image object.

The image below illustrates the distances used to specify a picture's placement on a worksheet.

Shape_Distances

The inserted picture has FloatingObject.Placement set to Placement.FreeFloating.

Examples

Dim imageUri As String = "http://www.devexpress.com/Products/NET/Document-Server/i/Unit-Conversion.png"
' Create an image from Uri.
Dim imageSource As SpreadsheetImageSource = SpreadsheetImageSource.FromUri(imageUri, workbook)
' Set the measurement unit to point.
workbook.Unit = DevExpress.Office.DocumentUnit.Point

workbook.BeginUpdate()
Try
    Dim worksheet As Worksheet = workbook.Worksheets(0)
    ' Insert a picture from the SpreadsheetImageSource at 100 pt from the left, 40 pt from the top, 
    ' and resize it to a width of 200 pt and a height of 180 pt.
    worksheet.Pictures.AddPicture(imageSource, 100, 40, 200, 180)
Finally
    workbook.EndUpdate()
End Try
See Also