Picture.ChangeImage(Image, ImageReplacementMode) Method

Replaces the current worksheet image with a different image.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[Browsable(false)]
void ChangeImage(
    Image image,
    ImageReplacementMode mode = ImageReplacementMode.Stretch
)

VB.NET

<Browsable(False)>
Sub ChangeImage(
    image As Image,
    mode As ImageReplacementMode = ImageReplacementMode.Stretch
)

Parameters

Name	Type	Description
image	Image	The new image to insert.

Optional Parameters

Name	Type	Default	Description
mode	ImageReplacementMode	Stretch	Specifies how to resize the new image. If omitted, Stretch mode is used.

Remarks

The example below demonstrates how to replace an existing picture in a worksheet and insert a new picture at the same position. The mode parameter is set to KeepAspectRatio. This mode scales the new picture to fit the largest dimension (width or height) of the original picture. The other dimension is calculated based on the aspect ratio of the inserted image.

C#

using DevExpress.Spreadsheet;
using System.Drawing;
// ...

// Set measurement unit to inches.
workbook.Unit = DevExpress.Office.DocumentUnit.Inch;
Worksheet worksheet = workbook.Worksheets.ActiveWorksheet;
// Insert a picture from a file.
// The picture's top left corner is in the "B2" cell.
var picture = worksheet.Pictures.AddPicture(Image.FromFile(@"Images\DevAvLogo.png"), worksheet.Cells["B2"]);
// Specify the picture size.
picture.Width = 0.5f;
picture.Height = 1f;
// Replace the picture.
picture.ChangeImage(Image.FromFile(@"Images\DevExpressLogo.png"), ImageReplacementMode.KeepAspectRatio);

VB.NET

Imports DevExpress.Spreadsheet
Imports System.Drawing
' ...

' Set measurement unit to inches.
workbook.Unit = DevExpress.Office.DocumentUnit.Inch
Dim worksheet As Worksheet = workbook.Worksheets.ActiveWorksheet
' Insert a picture from a file.
' The picture's top left corner is in the "B2" cell.
Dim picture As Picture = worksheet.Pictures.AddPicture(Image.FromFile("Images\DevAvLogo.png"),
                                                      worksheet.Cells("B2"))
' Specify the picture size.
picture.Width = 0.5F
picture.Height = 1F
' Replace the picture.
picture.ChangeImage(Image.FromFile("Images\DevExpressLogo.png"), ImageReplacementMode.KeepAspectRatio)