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.