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 Write an Excel File in C#

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

Regan Pun

September 14, 2023

In this tutorial, you will learn how to read and write Excel files using IronXL in C# with Visual Studio 2022. The tutorial starts by ensuring you have the latest version of IronXL installed via the NuGet package manager. After setting up, the process begins by including the IronXL namespace in your project. You will learn how to load an Excel file using the workbook.load function and assign the default worksheet to a variable. The tutorial guides you through selecting a range of cells, iterating over them, and printing their values to the console, while also calculating a running total of numeric data. The next step is to validate if the sum of the range's values matches a specific cell's value. If it does, confirmation is printed to the console. You will then modify a cell value (B2) by setting it to 11.54 and save the changes to a new Excel file named 'modified.xlsx'. The console output will display the cell contents and validation results, and the tutorial concludes by showing the modified Excel file with updated data. This tutorial is an excellent resource for those looking to enhance their skills in manipulating Excel files programmatically using C# and IronXL.

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 Read Excel Files in C# using IronXL

NEXT >
How to Create an Excel File in C# using IronXL