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.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

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

VB.NET

Function AddPicture(
    imageSource As SpreadsheetImageSource,
    x As Single,
    y As Single,
    width As Single,
    height As Single
) As Picture

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.

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

Example

View Example

PictureActions.vb

Dim imageUri As String = "https://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

PictureActions.cs

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

workbook.BeginUpdate();
try
{
    Worksheet 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();
}

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AddPicture(SpreadsheetImageSource, Single, Single, Single, Single) method.

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-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/PictureActions.cs#L53

    // and resize it to a width of 300 pt and a height of 200 pt.
    worksheet.Pictures.AddPicture(imageSource, 100, 40, 300, 200);
}

winforms-spreadsheetcontrol-api-part-2/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/PictureActions.cs#L72

    // and resize it to a width of 200 pt and a height of 180 pt.
    worksheet.Pictures.AddPicture(imageSource, 100, 40, 200, 180);
}

VB.NET

wpf-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/ShapeActions.vb#L63

    ' and resize it to a width of 200 pt and a height of 180 pt.
    worksheet.Pictures.AddPicture(imageSource, 100, 40, 400, 300)
Finally

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/PictureActions.vb#L49

    ' and resize it to a width of 300 pt and a height of 200 pt.
    worksheet.Pictures.AddPicture(imageSource, 100, 40, 300, 200)
Finally

winforms-spreadsheetcontrol-api-part-2/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/PictureActions.vb#L69

    ' and resize it to a width of 200 pt and a height of 180 pt.
    worksheet.Pictures.AddPicture(imageSource, 100, 40, 200, 180)
Finally