Best Way to Read Excel File in C# with IronXL

What Is the Best Way to Read Excel Files in C#?

The best way to read Excel files in C# is using a dedicated library like IronXL that operates independently of Microsoft Office. This approach worked fine across .NET Framework and .NET Core projects alike, letting users parse spreadsheet data without version compatibility headaches.

IronXL basically provides an Excel reader that loads an entire file into a workbook object, giving you direct access to every worksheet, row, column, and cell. Unlike XML-based solutions that require managing hidden complexity, IronXL's API lets you reference cells using familiar Excel notation like sheet["A1"] or iterate through ranges with foreach loops.

Get stated with IronXL now.

Start for Free

How Do I Install the Excel Reader Library in Visual Studio?

Installation takes seconds via NuGet in Visual Studio. Run this command in the Package Manager Console:

Install-Package IronXL.Excel

The library supports multiple .NET versions, so whether your app targets .NET Framework 4.6.2+ or .NET Core 3.1+, IronXL integrates seamlessly. Once installed, add the IronXL reference to your code file and you're ready to start reading Excel files.

How Can I Load and Read an Excel Workbook?

Loading an Excel workbook requires just one line of code. The WorkBook.Load method accepts a filename and automatically detects the format, XLSX file, XLS file, or CSV files all work identically.

class Program
{
    public static void Main(string[] args)
    {
        // Load an Excel workbook from file
        WorkBook workbook = WorkBook.Load("financial_report.xlsx");
        // Access the first worksheet by index
        WorkSheet worksheet = workbook.WorkSheets[0];
        // Or get a specific sheet by name
        WorkSheet dataSheet = workbook.GetWorkSheet("Expenses");
        Console.WriteLine($"Loaded workbook with {workbook.WorkSheets.Count} sheets");
    }
}

class Program
{
    public static void Main(string[] args)
    {
        // Load an Excel workbook from file
        WorkBook workbook = WorkBook.Load("financial_report.xlsx");
        // Access the first worksheet by index
        WorkSheet worksheet = workbook.WorkSheets[0];
        // Or get a specific sheet by name
        WorkSheet dataSheet = workbook.GetWorkSheet("Expenses");
        Console.WriteLine($"Loaded workbook with {workbook.WorkSheets.Count} sheets");
    }
}

IRON VB CONVERTER ERROR developers@ironsoftware.com

How Do I Read Cell Values from an Excel Worksheet?

Reading cells involves accessing them by address or iterating through ranges. IronXL provides strongly-typed properties like StringValue, IntValue, and DecimalValue to parse cell data into the correct system type.

using IronXL;
using System;
WorkBook workbook = WorkBook.Load("Products.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Read individual cell values with type conversion
string productName = sheet["A2"].StringValue;
int quantity = sheet["B2"].IntValue;
decimal price = sheet["C2"].DecimalValue;
// Check for null or empty cells before processing
var cell = sheet["D2"];
if (cell.Value != null)
{
    Console.WriteLine($"Product: {productName}, Qty: {quantity}, Price: {price}");
}
// Access cells using row and column index (zero-based)
int columnIndex = 0;
var firstCell = sheet.Rows[1].Columns[columnIndex];

using IronXL;
using System;
WorkBook workbook = WorkBook.Load("Products.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Read individual cell values with type conversion
string productName = sheet["A2"].StringValue;
int quantity = sheet["B2"].IntValue;
decimal price = sheet["C2"].DecimalValue;
// Check for null or empty cells before processing
var cell = sheet["D2"];
if (cell.Value != null)
{
    Console.WriteLine($"Product: {productName}, Qty: {quantity}, Price: {price}");
}
// Access cells using row and column index (zero-based)
int columnIndex = 0;
var firstCell = sheet.Rows[1].Columns[columnIndex];

IRON VB CONVERTER ERROR developers@ironsoftware.com

How Can I Iterate Through Rows and Cells?

Processing an entire file typically involves looping through rows and cells. The foreach pattern makes this elegant and readable, perfect for data extraction or validation tasks.

using IronXL;
using System;
 WorkBook workbook = WorkBook.Load(@"financial_report.xlsx");
 WorkSheet sheet = workbook.WorkSheets[0];
 // Skip column headers in first row, process data rows
 foreach (var row in sheet["A2:D7"])
 {
     Console.WriteLine($"Cell {row.AddressString}: {row.Text}");
 }
 // Iterate through specific row range
 for (int i = 1; i < sheet.Rows.Length; i++)
 {
     var currentRow = sheet.Rows[i];
     // Access each column in the row
     foreach (var cell in currentRow)
     {
         if (cell.Value != null)
         {
             Console.Write($"{cell.StringValue}\t");
         }
     }
     Console.WriteLine();
 }

using IronXL;
using System;
 WorkBook workbook = WorkBook.Load(@"financial_report.xlsx");
 WorkSheet sheet = workbook.WorkSheets[0];
 // Skip column headers in first row, process data rows
 foreach (var row in sheet["A2:D7"])
 {
     Console.WriteLine($"Cell {row.AddressString}: {row.Text}");
 }
 // Iterate through specific row range
 for (int i = 1; i < sheet.Rows.Length; i++)
 {
     var currentRow = sheet.Rows[i];
     // Access each column in the row
     foreach (var cell in currentRow)
     {
         if (cell.Value != null)
         {
             Console.Write($"{cell.StringValue}\t");
         }
     }
     Console.WriteLine();
 }

IRON VB CONVERTER ERROR developers@ironsoftware.com

The range syntax ["A2:D100"] creates an iterable collection of cells. This approach efficiently handles large spreadsheets without loading unnecessary data. You can also access the Rows and Columns collections directly when you need row-by-row or column-by-column processing.

How Do I Parse Multiple Excel Formats?

IronXL handles various Excel formats transparently. Whether you're reading legacy XLS files, modern XLSX files, or plain CSV files, the same code works across all formats.

using IronXL;
// Load different format types - the API remains consistent
WorkBook xlsxBook = WorkBook.Load("Modern.xlsx");
WorkBook xlsBook = WorkBook.Load("Legacy.xls");
WorkBook csvBook = WorkBook.Load("Data.csv");
// All workbooks expose identical worksheet access
WorkSheet sheet1 = xlsxBook.DefaultWorkSheet;
WorkSheet sheet2 = xlsBook.DefaultWorkSheet;
WorkSheet sheet3 = csvBook.DefaultWorkSheet;
// Write to different formats
xlsxBook.SaveAs("Output.csv");
csvBook.SaveAs("Converted.xlsx");

using IronXL;
// Load different format types - the API remains consistent
WorkBook xlsxBook = WorkBook.Load("Modern.xlsx");
WorkBook xlsBook = WorkBook.Load("Legacy.xls");
WorkBook csvBook = WorkBook.Load("Data.csv");
// All workbooks expose identical worksheet access
WorkSheet sheet1 = xlsxBook.DefaultWorkSheet;
WorkSheet sheet2 = xlsBook.DefaultWorkSheet;
WorkSheet sheet3 = csvBook.DefaultWorkSheet;
// Write to different formats
xlsxBook.SaveAs("Output.csv");
csvBook.SaveAs("Converted.xlsx");

IRON VB CONVERTER ERROR developers@ironsoftware.com

This format flexibility proves helpful when your program must handle files from different sources. The library automatically detects Excel formats from file extensions and content headers, so you don't need format-specific code paths. For CSV files, IronXL respects common conventions like comma delimiters and quoted string values.

What Advanced Operations Can I Perform?

Beyond basic reading, IronXL supports aggregate calculations, LINQ queries, and data manipulation. These advance features transform raw spreadsheet data into actionable insights.

using IronXL;
using System;
using System.Linq;
WorkBook workbook = WorkBook.Load("Financials.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Calculate sum of values in a range
decimal totalSales = sheet["B2:B50"].Sum();
// Use LINQ for advanced queries
decimal maxValue = sheet["C2:C50"].Max(c => c.DecimalValue);
var highValues = sheet["C2:C50"].Where(c => c.DecimalValue > 1000);
// Create instance of calculated results
Console.WriteLine($"Total: {totalSales}, Maximum: {maxValue}");
// Modify and save changes
sheet["D2"].Value = totalSales;
workbook.Save();

using IronXL;
using System;
using System.Linq;
WorkBook workbook = WorkBook.Load("Financials.xlsx");
WorkSheet sheet = workbook.DefaultWorkSheet;
// Calculate sum of values in a range
decimal totalSales = sheet["B2:B50"].Sum();
// Use LINQ for advanced queries
decimal maxValue = sheet["C2:C50"].Max(c => c.DecimalValue);
var highValues = sheet["C2:C50"].Where(c => c.DecimalValue > 1000);
// Create instance of calculated results
Console.WriteLine($"Total: {totalSales}, Maximum: {maxValue}");
// Modify and save changes
sheet["D2"].Value = totalSales;
workbook.Save();

IRON VB CONVERTER ERROR developers@ironsoftware.com

Summary

Reading Excel files in C# doesn't have to be complicated. IronXL provides a modern, dependency-free approach that works across .NET Framework and .NET Core projects. From loading a simple XLSX file to performing complex LINQ queries on cell data, the library handles it all with clean, readable code.

The examples in this post demonstrate core patterns you'll use daily: loading workbooks, accessing worksheets, reading cell values, and iterating through data. These patterns scale from simple scripts to enterprise applications without modification.

Ready to simplify your Excel file processing? Purchase a license to unlock the full potential of IronXL in production, or explore the complete API reference for additional details on available methods and properties.