officefileapi-devexpress-dot-spreadsheet-dot-picturecollection-dot-addpicture-x28-system-dot-drawing-dot-image-devexpress-dot-spreadsheet-dot-cellrange-system-dot-boolean-x29.md
Inserts an image that fits into the specified range. Allows you to lock the aspect ratio.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
[Browsable(false)]
Picture AddPicture(
Image image,
CellRange targetRange,
bool lockAspectRatio
)
<Browsable(False)>
Function AddPicture(
image As Image,
targetRange As CellRange,
lockAspectRatio As Boolean
) As Picture
| Name | Type | Description |
|---|---|---|
| image | Image |
A Image object that is the image to insert.
| | targetRange | CellRange |
A CellRange to which the inserted picture fits.
| | lockAspectRatio | Boolean |
true to lock the aspect ratio; otherwise,false.
|
| Type | Description |
|---|---|
| Picture |
A Picture object that is the inserted picture.
|
The image is resized to fit in the specified range.
The inserted picture has FloatingObject.Placement set to Placement.MoveAndSize.
Use the PictureCollection.AddPicture(SpreadsheetImageSource, CellRange, Boolean) overload instead of this overload on non-Windows environments.
The following code snippets (auto-collected from DevExpress Examples) contain references to the AddPicture(Image, CellRange, Boolean) 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.
web-dashboard-custom-info-exported-excel/CS/WebDashboardForm.aspx.cs#L39
sheet.Rows.Insert(0, 3);
sheet.Pictures.AddPicture(Properties.Resources.dxLogo, sheet.Range.FromLTRB(0, 0, 5, 2), true);
Cell textCell = sheet.Cells[0, 5];
winforms-dashboard-customize-exported-document/VB/CustomExportDocumentExample/Form1.vb#L48
sheet.Rows.Insert(0, 3)
sheet.Pictures.AddPicture(My.Resources.dxLogo, sheet.Range.FromLTRB(0, 0, 5, 2), True)
Dim textCell As Cell = sheet.Cells(0, 5)
web-dashboard-custom-info-exported-excel/VB/WebDashboardForm.aspx.vb#L42
sheet.Rows.Insert(0, 3)
sheet.Pictures.AddPicture(Properties.Resources.dxLogo, sheet.Range.FromLTRB(0, 0, 5, 2), True)
Dim textCell As Cell = sheet.Cells(0, 5)
See Also
Charts and Graphics in Spreadsheet Documents