Add, Extract & Remove Worksheet Images

Add Images Example

To insert an image into a spreadsheet, use the InsertImage method. It supports various image types, such as JPG/JPEG, BMP, PNG, GIF, and TIFF. You need to specify the top-left and bottom-right corners of the image to determine its dimensions, which are calculated by subtracting the column and row values.

  • For a 1x1 image size: worksheet.InsertImage("image.gif", 5, 1, 6, 2);
  • For a 2x2 image size: worksheet.InsertImage("image.gif", 5, 1, 7, 3);

Extract Images Example

To extract images from the selected worksheet, access the Images property, which provides a list of all the images contained within the sheet. From this list, you can perform various operations such as exporting, resizing, retrieving positions, and obtaining the byte data of each image. Notably, the image IDs follow an odd-numbered pattern, incrementing in the sequence of 1, 3, 5, 7, and so on.

Remove Image Example

Following the extract images example, you can easily remove any inserted image using its corresponding index number. Simply pass the image's ID number to the RemoveImage method to remove it from the worksheet.