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

A Comparison Between IronXL and ClosedXML

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

Regan Pun

November 1, 2023

In this video, a comparative analysis is conducted between two prominent .NET libraries, Iron XL and Close XML, focusing on their capabilities in reading Excel files. Both libraries are popular in handling Excel data, but they have distinct differences. The video begins by demonstrating how to read an Excel file using the Close XML library, which involves creating an instance of the Excel workbook class and reading the data with a for loop. This approach is noted as somewhat complex. In contrast, the Iron XL library is showcased for its simplicity and versatility. It allows reading the Excel file using a foreach loop, offering support for almost all spreadsheet formats, unlike Close XML, which is limited to Excel files only. The video concludes by recommending Iron XL for users seeking a library with broader file compatibility and ease of use. Viewers are encouraged to subscribe for more tutorials and try a trial subscription of Iron Software for further exploration.

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
C# Excel Tutorial: Learn to use IronXL Library (No Interop)

NEXT >
How to Read CSV files in C# using IronXL