Skip to main content
All docs
V24.2

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

How to: Replace a Worksheet Picture

  • 2 minutes to read

Use the Picture.ChangeImage method to replace an existing worksheet picture and insert a new picture at the same position. The method’s mode parameter specifies how to resize the new picture. You can set this parameter to one of the following ImageReplacementMode enumeration members:

Stretch (default mode)

This mode is used when you call the Picture.ChangeImage method without the mode parameter. It allows you to maintain the original picture’s size.

Replace a worksheet image - Stretch image

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.

Replace a worksheet image - Keep aspect ratio

UseActualSize

Select this mode when you need to keep the new picture’s original dimensions.

Replace a worksheet image - Use actual size

The following example demonstrates how replace an existing picture in a worksheet:

using DevExpress.Spreadsheet;
// ...

// 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(@"Images\DevAvLogo.png", worksheet.Cells["B2"]);
// Specify the picture size.
picture.Width = 0.5f;
picture.Height = 1f;
// Replace the picture.
picture.ChangeImage(@"Images\DevExpressLogo.png", ImageReplacementMode.KeepAspectRatio);
See Also