How to Add, Extract, and Remove Images from Worksheets

// Import the IronXL library which is used for Excel operations
using IronXL;

// Create a new Workbook instance
WorkBook workBook = WorkBook.Create();

// Get the default worksheet from the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Insert an image "ironpdf.jpg" into the worksheet at the specified cell range.
// The parameters in InsertImage specify the file name, starting column index, starting row index, ending column index, and ending row index.
workSheet.InsertImage("ironpdf.jpg", startColumnIndex: 2, startRowIndex: 2, endColumnIndex: 4, endRowIndex: 4);

// Insert another image "ironpdfIcon.png" into the worksheet at a different cell range
workSheet.InsertImage("ironpdfIcon.png", startColumnIndex: 2, startRowIndex: 6, endColumnIndex: 4, endRowIndex: 8);

// Save the workbook to a file named "insertImages.xlsx"
workBook.SaveAs("insertImages.xlsx");

' Import the IronXL library which is used for Excel operations

Imports IronXL



' Create a new Workbook instance

Private workBook As WorkBook = WorkBook.Create()



' Get the default worksheet from the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Insert an image "ironpdf.jpg" into the worksheet at the specified cell range.

' The parameters in InsertImage specify the file name, starting column index, starting row index, ending column index, and ending row index.

workSheet.InsertImage("ironpdf.jpg", startColumnIndex:= 2, startRowIndex:= 2, endColumnIndex:= 4, endRowIndex:= 4)



' Insert another image "ironpdfIcon.png" into the worksheet at a different cell range

workSheet.InsertImage("ironpdfIcon.png", startColumnIndex:= 2, startRowIndex:= 6, endColumnIndex:= 4, endRowIndex:= 8)



' Save the workbook to a file named "insertImages.xlsx"

workBook.SaveAs("insertImages.xlsx")

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

// Load the Excel workbook from a file
var workBook = WorkBook.Load("insertImages.xlsx");

// Get the default worksheet from the workbook
var workSheet = workBook.DefaultWorkSheet;

// Retrieve the list of images from the worksheet
var images = workSheet.Images;

// Iterate over each image in the list
foreach (var image in images)
{
    // Convert the image to AnyBitmap and save it as a PNG file
    AnyBitmap anyBitmap = image.ToAnyBitmap();
    anyBitmap.SaveAs($"{image.Id}.png");

    // Resize the image with width multiplier as 1 and height multiplier as 3
    image.Resize(1, 3);

    // Get the image's position in terms of row and column indexes
    Position position = image.Position;
    Console.WriteLine("Top row index: " + position.TopRowIndex);
    Console.WriteLine("Bottom row index: " + position.BottomRowIndex);

    // Retrieve byte array data of the image
    byte[] imageByte = image.Data;
    // The `imageByte` variable can be used for further processing if needed
}

// Save the modified workbook to a new file
workBook.SaveAs("resizeImage.xlsx");

Imports IronSoftware.Drawing

Imports IronXL

Imports IronXL.Drawing

Imports System

Imports System.Collections.Generic



' Load the Excel workbook from a file

Private workBook = WorkBook.Load("insertImages.xlsx")



' Get the default worksheet from the workbook

Private workSheet = workBook.DefaultWorkSheet



' Retrieve the list of images from the worksheet

Private images = workSheet.Images



' Iterate over each image in the list

For Each image In images

	' Convert the image to AnyBitmap and save it as a PNG file

	Dim anyBitmap As AnyBitmap = image.ToAnyBitmap()

	anyBitmap.SaveAs($"{image.Id}.png")



	' Resize the image with width multiplier as 1 and height multiplier as 3

	image.Resize(1, 3)



	' Get the image's position in terms of row and column indexes

	Dim position As Position = image.Position

	Console.WriteLine("Top row index: " & position.TopRowIndex)

	Console.WriteLine("Bottom row index: " & position.BottomRowIndex)



	' Retrieve byte array data of the image

	Dim imageByte() As Byte = image.Data

	' The `imageByte` variable can be used for further processing if needed

Next image



' Save the modified workbook to a new file

workBook.SaveAs("resizeImage.xlsx")

// This code demonstrates how to remove an image from an Excel worksheet using IronXL.

using IronXL;

// Load the workbook from an existing Excel file.
WorkBook workBook = WorkBook.Load("insertImages.xlsx");

// Get the default worksheet from the workbook.
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Check if the worksheet has enough images before attempting to remove.
// Remove an image from the worksheet by its index.
// Indexing is zero-based, so index 3 refers to the fourth image.
if (workSheet.Images.Count > 3)
{
    workSheet.RemoveImage(3);
    // Informative comment: This will remove the fourth image due to zero-based indexing.
}
else
{
    // Informative comment: If there are fewer than four images, an error would occur, so handle accordingly.
    Console.WriteLine("There are fewer than four images, so the fourth image cannot be removed.");
}

// Save the workbook after the image has been removed.
workBook.SaveAs("removeImage.xlsx");
// The workbook is saved with the name 'removeImage.xlsx' having the fourth image removed if it existed.

' This code demonstrates how to remove an image from an Excel worksheet using IronXL.



Imports IronXL



' Load the workbook from an existing Excel file.

Private workBook As WorkBook = WorkBook.Load("insertImages.xlsx")



' Get the default worksheet from the workbook.

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Check if the worksheet has enough images before attempting to remove.

' Remove an image from the worksheet by its index.

' Indexing is zero-based, so index 3 refers to the fourth image.

If workSheet.Images.Count > 3 Then

	workSheet.RemoveImage(3)

	' Informative comment: This will remove the fourth image due to zero-based indexing.

Else

	' Informative comment: If there are fewer than four images, an error would occur, so handle accordingly.

	Console.WriteLine("There are fewer than four images, so the fourth image cannot be removed.")

End If



' Save the workbook after the image has been removed.

workBook.SaveAs("removeImage.xlsx")

' The workbook is saved with the name 'removeImage.xlsx' having the fourth image removed if it existed.