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 of IronXL vs Microsoft Office Interop Excel

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

Regan Pun

October 25, 2022

In this comparison between Iron Excel and Microsoft Interop Excel, the video explores the installation, functionality, and performance aspects of both libraries. Microsoft Interop Excel requires installing Microsoft locally, which can be cumbersome due to its prolonged processing speed and extensive coding requirements. It only supports Windows platforms, making it incompatible with Linux, Mac OS, AWS, and Azure websites. On the other hand, Iron Excel is praised for its simplicity and efficiency. It allows users to refer to cells by their actual names, such as A1 or B2, and provides a straightforward way to apply formulas and formatting. Iron Excel supports multiple formats for saving and exporting, such as CSV, TSV, and JSON, and is compatible with all modern operating systems and .NET frameworks. The video concludes by recommending Iron Excel's free 30-day trial for users to experience its benefits firsthand, highlighting its fast processing speed and ease of use in creating, reading, and editing Excel files.

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
A Comparison of NPOI vs IronXL