Add, Extract & Remove Worksheet Images

VB C#

using IronXL;
using IronSoftware.Drawing;
using System.Collections.Generic;

WorkBook workBook = WorkBook.Create();
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Insert images
workSheet.InsertImage("ironpdf.jpg", 2, 2, 4, 4);
workSheet.InsertImage("ironpdfIcon.png", 2, 6, 4, 8);

// Retreive images
List<IronXL.Drawing.Images.IImage> images = workSheet.Images;
// Select each image
foreach (IronXL.Drawing.Images.IImage image in images)
{
    // Save the image
    AnyBitmap anyBitmap = image.ToAnyBitmap();
    anyBitmap.SaveAs($"{image.Id}.png");
}

// Remove image
workSheet.RemoveImage(3);

workBook.SaveAs("images.xlsx");

Imports IronXL
Imports IronSoftware.Drawing
Imports System.Collections.Generic

Private workBook As WorkBook = WorkBook.Create()
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Insert images
workSheet.InsertImage("ironpdf.jpg", 2, 2, 4, 4)
workSheet.InsertImage("ironpdfIcon.png", 2, 6, 4, 8)

' Retreive images
Dim images As List(Of IronXL.Drawing.Images.IImage) = workSheet.Images
' Select each image
For Each image As IronXL.Drawing.Images.IImage In images
	' Save the image
	Dim anyBitmap As AnyBitmap = image.ToAnyBitmap()
	anyBitmap.SaveAs($"{image.Id}.png")
Next image

' Remove image
workSheet.RemoveImage(3)

workBook.SaveAs("images.xlsx")

Install-Package IronXL.Excel

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.