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 Read CSV files in C# using IronXL

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

Regan Pun

April 18, 2022

In this tutorial, we explore how to read CSV files in C# using the IronXL library, a free tool for development. The process begins with installing IronXL via the package manager console. After installation, we integrate it into our project by adding the necessary namespace. We then demonstrate reading data from a CSV file using the workbook.loadCSV method, specifying the file path and name. By accessing the default worksheet, we can loop through the data cells, extracting values from a specified range (A1 to A10) and displaying them in the console.

Additionally, the tutorial covers performing aggregation functions on the data, such as calculating the sum and minimum values within the range. This is achieved using LINQ with decimal.Sum and decimal.Min functions, showcasing the flexibility and power of IronXL for data manipulation. The tutorial concludes with a successful demonstration of these operations, encouraging users to reach out to the support team for further assistance if needed.

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 Between IronXL and ClosedXML

NEXT >
How to Read Excel Data and Insert to Database Table in C#