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 Create Hyperlinks in Excel Using C#

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

Regan Pun

April 16, 2025

In this tutorial, viewers learn how to set up hyperlinks in Excel files using the Iron XL library. The process begins with ensuring the Iron XL library is installed via the Nougat package manager. The tutorial walks through a basic script that includes using statements for accessing Iron XL features, creating workbooks, and worksheets. It explains how to set a hyperlink in cell A1 to the ironpdf.com website and how to navigate within the same worksheet by clicking on cell A1 to jump to cell Z20. Additionally, it demonstrates setting hyperlinks across different worksheets, such as linking cell A3 to cell A1 of sheet 2, and opening external Excel files by clicking on cell A5. The tutorial concludes by running the project to verify that links work as expected, showcasing the powerful interactivity features that Iron XL offers for Excel files. Viewers are encouraged to subscribe for more tutorials and explore the software by following the provided link.

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 Load Existing Spreadsheets in C#

NEXT >
How to Group and Ungroup Rows and Columns in Excel