using IronXL; using System; using System.Linq; // Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV WorkBook workBook = WorkBook.Load("sample.xlsx"); // Select worksheet at index 0 WorkSheet workSheet = workBook.WorkSheets[0]; // Get any existing worksheet WorkSheet firstSheet = workBook.DefaultWorkSheet; // Select a cell and return the converted value int cellValue = workSheet["A2"].IntValue; // Read from ranges of cells elegantly. foreach (var cell in workSheet["A2:A10"]) { Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text); } // Calculate aggregate values such as Min, Max and Sum decimal sum = workSheet["A2:A10"].Sum(); // Linq compatible decimal max = workSheet["A2:A10"].Max(c => c.DecimalValue);

VIDEOS

How to Add, Extract, and Remove Images from Worksheets

Name: IronXL
Brand: Iron Software
Availability: InStock
Rating: 4.67 (175 reviews)

Regan Pun

March 31, 2024

In this tutorial, we delve into the process of handling images within Excel spreadsheets using the IronXL library in C#. The session begins with the installation of the IronXL library via the NuGet package manager. First, we import the necessary namespaces for drawing and IronXL functionalities. A new Excel workbook is created, and its default worksheet is selected. The 'insert image' method is employed, which requires the image file path and its dimensions, defined by the top left and bottom right corners of the spreadsheet. We then retrieve a list of images in the worksheet using the 'images' property, looping through each image to convert it into a bitmap object for saving. Additionally, the tutorial demonstrates how to remove images using the 'remove image' method by specifying the image ID. Finally, all changes are saved into a new Excel file, named 'insert images.xlsx'. Upon running the project, the Excel file successfully displays the added images, appropriately sized and positioned. The tutorial concludes with a brief on checking the extracted photos saved as individual PNG files with unique IDs. Viewers are encouraged to engage with the content by liking, subscribing, and trying out the software through a trial subscription.

Get stated with IronXL now.

Regan Pun

Chat with engineering team now

Software Engineer

Regan graduated from the University of Reading, with a BA in Electronic Engineering. Before joining Iron Software, his previous job roles had him laser-focused on single tasks; and what he most enjoys at Iron Software is the spectrum of work he gets to undertake, whether it’s adding value to sales, technical support, product development or marketing. He enjoys understanding the way developers are using the Iron Software library, and using that knowledge to continually improve documentation and develop the products.

< PREVIOUS
How to Add Freeze Panes to Spreadsheets in Excel

NEXT >
C# Excel Tutorial: Learn to use IronXL Library (No Interop)