How to Read Excel Files in C# Instead of Using StreamReader

Why Can't StreamReader Read Excel Files?

StreamReader is a text-based reader. It reads character data line by line using a specified encoding (UTF-8, ASCII, etc.) and has no awareness of binary structures or compressed archives. The official .NET StreamReader documentation confirms that this class is designed exclusively for character-encoded text. Excel files, despite looking like simple spreadsheets, are actually complex binary or ZIP-compressed XML structures that StreamReader cannot interpret.

When you open an XLSX file with StreamReader, you are essentially trying to read a ZIP archive as plain text. The result is a stream of binary noise rather than your spreadsheet data.

// This code will NOT work -- demonstrates the problem
using StreamReader reader = new StreamReader("ProductData.xlsx");
string content = reader.ReadLine();
Console.WriteLine(content); // Outputs garbled binary data like "PK♥♦"

// This code will NOT work -- demonstrates the problem
using StreamReader reader = new StreamReader("ProductData.xlsx");
string content = reader.ReadLine();
Console.WriteLine(content); // Outputs garbled binary data like "PK♥♦"

When you run this snippet, instead of seeing your spreadsheet rows, you encounter binary characters such as PK♥♦ or similar noise. This happens because:

• XLSX files are ZIP archives containing multiple XML files: worksheets, styles, shared strings, relationships. The Open XML SDK documentation provides a detailed breakdown of this structure.
• XLS files use a proprietary binary format (BIFF -- Binary Interchange File Format)
• StreamReader applies a character encoding to whatever bytes it reads, producing meaningless output for both formats

How Do You Install IronXL in a .NET Project?

IronXL is a .NET library that reads, writes, and creates Excel files without requiring Microsoft Excel to be installed. It supports XLSX, XLS, XLSM, CSV, and TSV formats, and runs on Windows, Linux, macOS, and Docker containers.

To install IronXL, use either the NuGet Package Manager Console or the .NET CLI. The package is published on NuGet.org as IronXL:

Install-Package IronXL
dotnet add package IronXL

Install-Package IronXL
dotnet add package IronXL

After installation, add the using IronXL; directive to your file and you are ready to work with Excel documents.

For detailed installation steps and NuGet configuration options, see the IronXL NuGet installation guide. A free trial license is available so you can evaluate IronXL in your project before purchasing.

How Do You Read Excel Files with IronXL?

IronXL provides an intuitive API for reading Excel files in C#. Unlike StreamReader, IronXL understands Excel's internal structure and gives you clean access to rows, columns, and cell values. The IronXL documentation provides full API references for all supported operations.

Here is how to read an Excel file using IronXL with top-level statements:

using IronXL;

// Load the Excel file from disk
WorkBook workbook = WorkBook.Load("ProductData.xlsx");
WorkSheet worksheet = workbook.DefaultWorkSheet;

// Read a specific cell by address
string cellValue = worksheet["A1"].StringValue;
Console.WriteLine($"Cell A1 contains: {cellValue}");

// Iterate over a range of cells
foreach (var cell in worksheet["A1:C10"])
{
    Console.WriteLine($"{cell.AddressString}: {cell.Text}");
}

// Read a numeric value
decimal price = worksheet["B2"].DecimalValue;
Console.WriteLine($"Price: {price:C}");

using IronXL;

// Load the Excel file from disk
WorkBook workbook = WorkBook.Load("ProductData.xlsx");
WorkSheet worksheet = workbook.DefaultWorkSheet;

// Read a specific cell by address
string cellValue = worksheet["A1"].StringValue;
Console.WriteLine($"Cell A1 contains: {cellValue}");

// Iterate over a range of cells
foreach (var cell in worksheet["A1:C10"])
{
    Console.WriteLine($"{cell.AddressString}: {cell.Text}");
}

// Read a numeric value
decimal price = worksheet["B2"].DecimalValue;
Console.WriteLine($"Price: {price:C}");

The WorkBook.Load method automatically detects the file format (XLSX, XLS, XLSM, CSV) and handles all the complex parsing. You access cells using standard Excel notation such as "A1" or ranges such as "A1:C10", which makes the code immediately readable to anyone familiar with spreadsheets.

using IronXL;

WorkBook workbook = WorkBook.Load("MultiSheet.xlsx");

// List all worksheets
foreach (WorkSheet sheet in workbook.WorkSheets)
{
    Console.WriteLine($"Sheet: {sheet.Name}, Rows: {sheet.RowCount}");
}

// Access a sheet by name
WorkSheet summary = workbook.GetWorkSheet("Summary");
string totalRevenue = summary["B20"].StringValue;
Console.WriteLine($"Total Revenue: {totalRevenue}");

// Access a sheet by index
WorkSheet firstSheet = workbook.WorkSheets[0];
int lastRow = firstSheet.RowCount;
Console.WriteLine($"Last row in first sheet: {lastRow}");

using IronXL;

WorkBook workbook = WorkBook.Load("MultiSheet.xlsx");

// List all worksheets
foreach (WorkSheet sheet in workbook.WorkSheets)
{
    Console.WriteLine($"Sheet: {sheet.Name}, Rows: {sheet.RowCount}");
}

// Access a sheet by name
WorkSheet summary = workbook.GetWorkSheet("Summary");
string totalRevenue = summary["B20"].StringValue;
Console.WriteLine($"Total Revenue: {totalRevenue}");

// Access a sheet by index
WorkSheet firstSheet = workbook.WorkSheets[0];
int lastRow = firstSheet.RowCount;
Console.WriteLine($"Last row in first sheet: {lastRow}");

How Do You Read Excel Data from a Memory Stream?

Real-world applications often need to process Excel files from streams rather than disk files. Common scenarios include handling file uploads from web forms, retrieving workbooks from a database BLOB column, or processing files downloaded from cloud storage (Azure Blob Storage, AWS S3). IronXL handles these scenarios through WorkBook.FromStream:

using IronXL;
using System.IO;

// Simulate reading file bytes (e.g., from a database or web upload)
byte[] fileBytes = File.ReadAllBytes("ProductData.xlsx");

using MemoryStream stream = new MemoryStream(fileBytes);
WorkBook workbook = WorkBook.FromStream(stream);
WorkSheet worksheet = workbook.DefaultWorkSheet;

// Get row and column counts
Console.WriteLine($"Rows: {worksheet.RowCount}, Columns: {worksheet.ColumnCount}");

// Convert to DataTable for database or grid binding
var dataTable = worksheet.ToDataTable(useHeaderRow: true);
Console.WriteLine($"Loaded {dataTable.Rows.Count} data rows");

foreach (System.Data.DataRow row in dataTable.Rows)
{
    string productName = row["ProductName"]?.ToString() ?? string.Empty;
    string sku = row["SKU"]?.ToString() ?? string.Empty;
    Console.WriteLine($"Product: {productName}, SKU: {sku}");
}

using IronXL;
using System.IO;

// Simulate reading file bytes (e.g., from a database or web upload)
byte[] fileBytes = File.ReadAllBytes("ProductData.xlsx");

using MemoryStream stream = new MemoryStream(fileBytes);
WorkBook workbook = WorkBook.FromStream(stream);
WorkSheet worksheet = workbook.DefaultWorkSheet;

// Get row and column counts
Console.WriteLine($"Rows: {worksheet.RowCount}, Columns: {worksheet.ColumnCount}");

// Convert to DataTable for database or grid binding
var dataTable = worksheet.ToDataTable(useHeaderRow: true);
Console.WriteLine($"Loaded {dataTable.Rows.Count} data rows");

foreach (System.Data.DataRow row in dataTable.Rows)
{
    string productName = row["ProductName"]?.ToString() ?? string.Empty;
    string sku = row["SKU"]?.ToString() ?? string.Empty;
    Console.WriteLine($"Product: {productName}, SKU: {sku}");
}

WorkBook.FromStream accepts any Stream -- MemoryStream, FileStream, or a network stream. This flexibility means you never have to write temporary files to disk just to read Excel data. The conversion to DataTable also integrates directly with SqlBulkCopy, data-binding controls, and reporting frameworks.

How Do You Convert Between Excel and CSV Formats?

While StreamReader can handle CSV files, production applications often need to move data between Excel and CSV. IronXL makes format conversion straightforward. You can export Excel data to CSV or import CSV data into a workbook in just a few lines:

using IronXL;

// Load an Excel file and save as CSV
WorkBook workbook = WorkBook.Load("SalesData.xlsx");
workbook.SaveAsCsv("output.csv");

// Load a CSV file and save as Excel
WorkBook csvWorkbook = WorkBook.LoadCSV("legacy-report.csv");
csvWorkbook.SaveAs("converted.xlsx");

// Export a specific worksheet to CSV
WorkSheet worksheet = workbook.WorkSheets[0];
worksheet.SaveAsCsv("sheet1-export.csv");

using IronXL;

// Load an Excel file and save as CSV
WorkBook workbook = WorkBook.Load("SalesData.xlsx");
workbook.SaveAsCsv("output.csv");

// Load a CSV file and save as Excel
WorkBook csvWorkbook = WorkBook.LoadCSV("legacy-report.csv");
csvWorkbook.SaveAs("converted.xlsx");

// Export a specific worksheet to CSV
WorkSheet worksheet = workbook.WorkSheets[0];
worksheet.SaveAsCsv("sheet1-export.csv");

These conversions preserve your data while changing the container format. When converting Excel to CSV, IronXL exports the first worksheet by default; you can specify any sheet you choose. Converting CSV to Excel creates a properly structured workbook that you can then format, add formulas to, and write additional data into.

How Do You Create and Format Excel Files with IronXL?

Reading Excel data is only part of the workflow. Many applications also need to create new Excel files and apply formatting. IronXL supports cell formatting including fonts, colors, borders, number formats, and cell merging:

using IronXL;

// Create a new workbook and worksheet
WorkBook workbook = WorkBook.Create(ExcelFileFormat.XLSX);
WorkSheet sheet = workbook.CreateWorkSheet("Report");

// Write headers with formatting
sheet["A1"].Value = "Product";
sheet["B1"].Value = "Units Sold";
sheet["C1"].Value = "Revenue";

// Apply bold formatting to header row
sheet["A1:C1"].Style.Font.Bold = true;
sheet["A1:C1"].Style.SetBackgroundColor("#4472C4");
sheet["A1:C1"].Style.Font.Color = "#FFFFFF";

// Write data rows
string[] products = { "Widget A", "Widget B", "Widget C" };
int[] units = { 120, 85, 210 };
decimal[] revenues = { 2400.00m, 1700.00m, 4200.00m };

for (int i = 0; i < products.Length; i++)
{
    sheet[$"A{i + 2}"].Value = products[i];
    sheet[$"B{i + 2}"].Value = units[i];
    sheet[$"C{i + 2}"].Value = revenues[i];
    sheet[$"C{i + 2}"].FormatString = "$#,##0.00";
}

// Save the workbook
workbook.SaveAs("FormattedReport.xlsx");
Console.WriteLine("Report created successfully.");

using IronXL;

// Create a new workbook and worksheet
WorkBook workbook = WorkBook.Create(ExcelFileFormat.XLSX);
WorkSheet sheet = workbook.CreateWorkSheet("Report");

// Write headers with formatting
sheet["A1"].Value = "Product";
sheet["B1"].Value = "Units Sold";
sheet["C1"].Value = "Revenue";

// Apply bold formatting to header row
sheet["A1:C1"].Style.Font.Bold = true;
sheet["A1:C1"].Style.SetBackgroundColor("#4472C4");
sheet["A1:C1"].Style.Font.Color = "#FFFFFF";

// Write data rows
string[] products = { "Widget A", "Widget B", "Widget C" };
int[] units = { 120, 85, 210 };
decimal[] revenues = { 2400.00m, 1700.00m, 4200.00m };

for (int i = 0; i < products.Length; i++)
{
    sheet[$"A{i + 2}"].Value = products[i];
    sheet[$"B{i + 2}"].Value = units[i];
    sheet[$"C{i + 2}"].Value = revenues[i];
    sheet[$"C{i + 2}"].FormatString = "$#,##0.00";
}

// Save the workbook
workbook.SaveAs("FormattedReport.xlsx");
Console.WriteLine("Report created successfully.");

This ability to both read existing workbooks and create new formatted files makes IronXL a complete Excel solution for .NET applications. Review the full IronXL features page for a detailed breakdown of supported operations.

How Do You License and Deploy IronXL in Production?

IronXL is free for development and testing. For production applications, a license is required. You can explore IronXL licensing options on the product page, which covers Developer, Team, and Organization tiers depending on your deployment requirements.

After purchasing, apply your license key in code before any IronXL calls:

IronXL.License.LicenseKey = "YOUR-LICENSE-KEY-HERE";

IronXL.License.LicenseKey = "YOUR-LICENSE-KEY-HERE";

Alternatively, set the IRONXL_LICENSE_KEY environment variable in your deployment environment and IronXL will pick it up automatically. This is the preferred approach for containerized deployments (Docker, Kubernetes) and cloud environments where hardcoding keys is not acceptable.

For evaluation purposes, a free trial license provides full functionality so you can validate IronXL against your specific workloads before committing to a purchase. The trial is available without a credit card and activates immediately.

Compared to alternatives such as Microsoft.Office.Interop.Excel, IronXL has several deployment advantages:

• No requirement for Microsoft Excel to be installed on the server
• Compatible with Linux and Docker -- critical for cloud-native applications
• No COM object lifecycle management or apartment threading issues
• Faster startup and lower memory usage in server contexts
• Consistent behavior across all supported platforms

These qualities make IronXL a practical choice for any .NET application that needs to process Excel files in production, whether on-premises or in the cloud.