使用 IRONXL

在 C# 中读取 CSV 文件：教程

Q: 我可以使用 C# 将 CSV 文件转换为 Excel 吗？

可以，IronXL 允许您通过加载 CSV 并使用 WorkBook.SaveAs 方法保存来将 CSV 文件转换为 XLS 或 XLSX 等 Excel 格式。

Q: 是否可以在 C# 中将 Excel 单元格数据解析为特定数据类型？

可以，使用 IronXL，您可以使用 Int32Value 和 BoolValue 等方法将 Excel 单元格值解析为数值和布尔等特定数据类型。

Q: 如何在 C# 中将 Excel 工作表转换为 DataTable？

您可以使用 IronXL 的 WorkSheet.ToDataTable 方法将 Excel 工作表转换为 DataTable，该方法可高效地将工作表解析为 DataTable 对象以供数据操作。

Curtis Chau

已更新:七月 28, 2025

Working with various Excel formats often requires reading data and then reconfiguring it programmatically. In this article, we will learn how to read a CSV file and parse data from an Excel spreadsheet in C# using IronXL, the perfect tool for the job.

What is CSV?

CSV is a simple data format, but there can be many differences; it can be difficult to read programmatically in our C# projects because it uses several delimiters for distinguishing between rows and columns of data. This article will show you how to use the IronXL library to read CSV files.

1. How to read a CSV File in C#

Before you can make use of IronXL to read CSV files in MVC, ASP.NET or .NET Core, you need to install it. Here is a quick walk-through.

In Visual Studio, select the Project menu
Manage NuGet Packages
Search for IronXL.Excel
Install

Reading CSV Files in C#: a Tutorial, Figure 1: Search for IronXL in NuGet Package Manager in Visual Studio Search for IronXL in NuGet Package Manager in Visual Studio

When you need to read CSV files in C#, IronXL is the perfect tool. You can read a CSV file with commas, or any other delimiter, as seen in the code segments below.

// Load a CSV file and interpret it as an Excel-like workbook
WorkBook workbook = WorkBook.LoadCSV("Weather.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

// Access the default worksheet in the workbook
WorkSheet ws = workbook.DefaultWorkSheet;

// Save the workbook to a new Excel file
workbook.SaveAs("Csv_To_Excel.xlsx");

// Load a CSV file and interpret it as an Excel-like workbook
WorkBook workbook = WorkBook.LoadCSV("Weather.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

// Access the default worksheet in the workbook
WorkSheet ws = workbook.DefaultWorkSheet;

// Save the workbook to a new Excel file
workbook.SaveAs("Csv_To_Excel.xlsx");

' Load a CSV file and interpret it as an Excel-like workbook
Dim workbook As WorkBook = WorkBook.LoadCSV("Weather.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")

' Access the default worksheet in the workbook
Dim ws As WorkSheet = workbook.DefaultWorkSheet

' Save the workbook to a new Excel file
workbook.SaveAs("Csv_To_Excel.xlsx")

$vbLabelText $csharpLabel

Output:

Reading CSV Files in C#: a Tutorial, Figure 2: Output CSV file with comma delimiter Output CSV file with comma delimiter

Code Explanation:

A WorkBook object is created. The LoadCSV method for the WorkBook object is then used to specify the name of the CSV, its format, and which delimiters are used in the CSV file being read. In this case, commas are used as delimiters.

A WorkSheet object is then created. This is where the contents of the CSV file will be placed. The file is saved under a new name and format.

Reading CSV Files in C#: a Tutorial, Figure 3: Data displayed in Microsoft Excel Data displayed in Microsoft Excel

2. IronXL for Excel Files

Use IronXL for your project as a streamlined way to work with Excel file formats in C#. You can either install IronXL via direct download. Alternatively, you can use NuGet Install for Visual Studio. The software is free for development.

dotnet add package IronXL.Excel

3. Load `WorkBook` and Access `WorkSheet`

WorkBook is the class of IronXL whose object provides full access to the Excel file and all of its functions. For example, if we want to access an Excel file, we'd use the code:

// Load the Excel file
WorkBook wb = WorkBook.Load("sample.xlsx"); // Excel file path

// Load the Excel file
WorkBook wb = WorkBook.Load("sample.xlsx"); // Excel file path

' Load the Excel file
Dim wb As WorkBook = WorkBook.Load("sample.xlsx") ' Excel file path

$vbLabelText $csharpLabel

To access the specific worksheet of an Excel file, IronXL provides the WorkSheet class.

// Access a specific worksheet by name
WorkSheet ws = wb.GetWorkSheet("Sheet1"); // by sheet name

// Access a specific worksheet by name
WorkSheet ws = wb.GetWorkSheet("Sheet1"); // by sheet name

' Access a specific worksheet by name
Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1") ' by sheet name

$vbLabelText $csharpLabel

Once you have obtained the Excel worksheet ws, you can extract any type of data from it and perform all Excel functions on it. Data can be accessed from the Excel worksheet ws through this process:

using IronXL;

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Iterate through a range of cells and display their values
        foreach (var cell in ws["A2:A10"])
        {
            Console.WriteLine("Value is: {0}", cell.Text);
        }
        Console.ReadKey();
    }
}

using IronXL;

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Iterate through a range of cells and display their values
        foreach (var cell in ws["A2:A10"])
        {
            Console.WriteLine("Value is: {0}", cell.Text);
        }
        Console.ReadKey();
    }
}

Imports IronXL

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Iterate through a range of cells and display their values
		For Each cell In ws("A2:A10")
			Console.WriteLine("Value is: {0}", cell.Text)
		Next cell
		Console.ReadKey()
	End Sub
End Class

$vbLabelText $csharpLabel

4. Reading an Excel WorkSheet as a DataTable

Using IronXL, it is very easy to operate with an Excel WorkSheet as a DataTable.

DataTable dt = ws.ToDataTable(true); // Converts the worksheet to a DataTable, using the first row as column names

DataTable dt = ws.ToDataTable(true); // Converts the worksheet to a DataTable, using the first row as column names

Dim dt As DataTable = ws.ToDataTable(True) ' Converts the worksheet to a DataTable, using the first row as column names

$vbLabelText $csharpLabel

Use the following namespaces:

using IronXL;
using System.Data;

using IronXL;
using System.Data;

Imports IronXL
Imports System.Data

$vbLabelText $csharpLabel

Write the following code:

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("Weather.xlsx"); // Your Excel file Name
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Parse worksheet into datatable
        DataTable dt = ws.ToDataTable(true); // Parse Sheet1 of sample.xlsx file into DataTable

        // Iterate through rows and columns to display their values
        foreach (DataRow row in dt.Rows) // Access rows
        {
            for (int i = 0; i < dt.Columns.Count; i++) // Access columns of corresponding row
            {
                Console.Write(row[i] + "  ");
            }
            Console.WriteLine();
        }
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("Weather.xlsx"); // Your Excel file Name
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Parse worksheet into datatable
        DataTable dt = ws.ToDataTable(true); // Parse Sheet1 of sample.xlsx file into DataTable

        // Iterate through rows and columns to display their values
        foreach (DataRow row in dt.Rows) // Access rows
        {
            for (int i = 0; i < dt.Columns.Count; i++) // Access columns of corresponding row
            {
                Console.Write(row[i] + "  ");
            }
            Console.WriteLine();
        }
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("Weather.xlsx") ' Your Excel file Name
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Parse worksheet into datatable
		Dim dt As DataTable = ws.ToDataTable(True) ' Parse Sheet1 of sample.xlsx file into DataTable

		' Iterate through rows and columns to display their values
		For Each row As DataRow In dt.Rows ' Access rows
			For i As Integer = 0 To dt.Columns.Count - 1 ' Access columns of corresponding row
				Console.Write(row(i) & "  ")
			Next i
			Console.WriteLine()
		Next row
	End Sub
End Class

$vbLabelText $csharpLabel

Reading CSV Files in C#: a Tutorial, Figure 4: Console output from a DataTable object Console output from a DataTable object

In this example, we will look at how to use an Excel file as a DataSet.

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and convert it to a DataSet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        DataSet ds = wb.ToDataSet(); // Parse WorkBook wb into DataSet

        // Iterate through tables to display their names
        foreach (DataTable dt in ds.Tables)
        {
            Console.WriteLine(dt.TableName);
        }
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and convert it to a DataSet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        DataSet ds = wb.ToDataSet(); // Parse WorkBook wb into DataSet

        // Iterate through tables to display their names
        foreach (DataTable dt in ds.Tables)
        {
            Console.WriteLine(dt.TableName);
        }
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and convert it to a DataSet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
		Dim ds As DataSet = wb.ToDataSet() ' Parse WorkBook wb into DataSet

		' Iterate through tables to display their names
		For Each dt As DataTable In ds.Tables
			Console.WriteLine(dt.TableName)
		Next dt
	End Sub
End Class

$vbLabelText $csharpLabel

Reading CSV Files in C#: a Tutorial, Figure 5: Access sheet name from DataSet object Access sheet name from DataSet object

Let's look at another example of how to access each cell value across all Excel sheets. Here, we can access each cell value of every WorkSheet in an Excel file.

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and convert it to a DataSet
        WorkBook wb = WorkBook.Load("Weather.xlsx");
        DataSet ds = wb.ToDataSet(); // Treat the complete Excel file as DataSet

        // Iterate through each table and its rows and columns
        foreach (DataTable dt in ds.Tables) // Treat Excel WorkSheet as DataTable
        {
            foreach (DataRow row in dt.Rows) // Corresponding Sheet's Rows
            {
                for (int i = 0; i < dt.Columns.Count; i++) // Sheet columns of corresponding row
                {
                    Console.Write(row[i] + "  ");
                }
                Console.WriteLine();
            }
        }
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and convert it to a DataSet
        WorkBook wb = WorkBook.Load("Weather.xlsx");
        DataSet ds = wb.ToDataSet(); // Treat the complete Excel file as DataSet

        // Iterate through each table and its rows and columns
        foreach (DataTable dt in ds.Tables) // Treat Excel WorkSheet as DataTable
        {
            foreach (DataRow row in dt.Rows) // Corresponding Sheet's Rows
            {
                for (int i = 0; i < dt.Columns.Count; i++) // Sheet columns of corresponding row
                {
                    Console.Write(row[i] + "  ");
                }
                Console.WriteLine();
            }
        }
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and convert it to a DataSet
		Dim wb As WorkBook = WorkBook.Load("Weather.xlsx")
		Dim ds As DataSet = wb.ToDataSet() ' Treat the complete Excel file as DataSet

		' Iterate through each table and its rows and columns
		For Each dt As DataTable In ds.Tables ' Treat Excel WorkSheet as DataTable
			For Each row As DataRow In dt.Rows ' Corresponding Sheet's Rows
				For i As Integer = 0 To dt.Columns.Count - 1 ' Sheet columns of corresponding row
					Console.Write(row(i) & "  ")
				Next i
				Console.WriteLine()
			Next row
		Next dt
	End Sub
End Class

$vbLabelText $csharpLabel

Reading CSV Files in C#: a Tutorial, Figure 6: Console output of Dataset object Console output of Dataset object

5. CSV parsing in C# .NET

CSV files have an abundance of issues with how line breaks are handled in fields, or how fields can be contained in quotes that completely block a simple string split approach. I have recently discovered the following options when converting CSV in C# .NET by specifying a customizable delimiter instead of using string.Split(',') to separate the values in a comma.

6. Reading CSV Data in C# Records

This process advances the reader through the next file. We read the CSV field files in TryGetField. We use the read function on field fields of the CSV files as record fields.

// Load a CSV file, specify the file format and delimiter
WorkBook workbook = WorkBook.LoadCSV("Weather.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

// Access the default worksheet from the workbook
WorkSheet ws = workbook.DefaultWorkSheet;

// Convert worksheet to DataTable    
DataTable dt = ws.ToDataTable(true); // Parse Sheet1 of sample.xlsx file into DataTable

// Iterate through rows and columns to display their values
foreach (DataRow row in dt.Rows) // Access rows
{
    for (int i = 0; i < dt.Columns.Count; i++) // Access columns of corresponding row
    {
        Console.Write(row[i] + "  ");
    }
    Console.WriteLine();
}

// Load a CSV file, specify the file format and delimiter
WorkBook workbook = WorkBook.LoadCSV("Weather.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

// Access the default worksheet from the workbook
WorkSheet ws = workbook.DefaultWorkSheet;

// Convert worksheet to DataTable    
DataTable dt = ws.ToDataTable(true); // Parse Sheet1 of sample.xlsx file into DataTable

// Iterate through rows and columns to display their values
foreach (DataRow row in dt.Rows) // Access rows
{
    for (int i = 0; i < dt.Columns.Count; i++) // Access columns of corresponding row
    {
        Console.Write(row[i] + "  ");
    }
    Console.WriteLine();
}

' Load a CSV file, specify the file format and delimiter
Dim workbook As WorkBook = WorkBook.LoadCSV("Weather.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")

' Access the default worksheet from the workbook
Dim ws As WorkSheet = workbook.DefaultWorkSheet

' Convert worksheet to DataTable    
Dim dt As DataTable = ws.ToDataTable(True) ' Parse Sheet1 of sample.xlsx file into DataTable

' Iterate through rows and columns to display their values
For Each row As DataRow In dt.Rows ' Access rows
	For i As Integer = 0 To dt.Columns.Count - 1 ' Access columns of corresponding row
		Console.Write(row(i) & "  ")
	Next i
	Console.WriteLine()
Next row

$vbLabelText $csharpLabel

Reading CSV Files in C#: a Tutorial, Figure 7: Console output from DataTable Console output from DataTable

7. Getting Data from Excel Files

Now we can easily get any type of data, using a variety of methods, from the open Excel WorkSheet. In the following example, we can see how to access a specific cell value and parse it to string:

// Access the data by cell addressing
string val = ws["Cell Address"].ToString();

// Access the data by cell addressing
string val = ws["Cell Address"].ToString();

' Access the data by cell addressing
Dim val As String = ws("Cell Address").ToString()

$vbLabelText $csharpLabel

In the line above, ws is the WorkSheet, which was defined in Step 2. This is 'the simple' approach, but you can read more and see different examples of how to access Excel file data.

8. How to Parse Excel Files in C#

When using Excel Spreadsheets for application builds, we often analyze the results based on data and need to parse Excel file data within C# into the required format to get the right results. Parsing data into different formats is made easy in the C# environment with the use of IronXL; see the steps below.

using IronXL;

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Parse Excel cell value into string
        string str_val = ws["B3"].Value.ToString();

        // Parse Excel cell value into Int32
        Int32 int32_val = ws["G3"].Int32Value;

        // Parse Excel cell value into Decimal
        decimal decimal_val = ws["E5"].DecimalValue;

        // Output parsed values to the console
        Console.WriteLine("Parse B3 Cell Value into String: {0}", str_val);
        Console.WriteLine("Parse G3 Cell Value into Int32: {0}", int32_val);
        Console.WriteLine("Parse E5 Cell Value into decimal: {0}", decimal_val);

        Console.ReadKey();
    }
}

using IronXL;

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Parse Excel cell value into string
        string str_val = ws["B3"].Value.ToString();

        // Parse Excel cell value into Int32
        Int32 int32_val = ws["G3"].Int32Value;

        // Parse Excel cell value into Decimal
        decimal decimal_val = ws["E5"].DecimalValue;

        // Output parsed values to the console
        Console.WriteLine("Parse B3 Cell Value into String: {0}", str_val);
        Console.WriteLine("Parse G3 Cell Value into Int32: {0}", int32_val);
        Console.WriteLine("Parse E5 Cell Value into decimal: {0}", decimal_val);

        Console.ReadKey();
    }
}

Imports IronXL

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Parse Excel cell value into string
		Dim str_val As String = ws("B3").Value.ToString()

		' Parse Excel cell value into Int32
		Dim int32_val As Int32 = ws("G3").Int32Value

		' Parse Excel cell value into Decimal
		Dim decimal_val As Decimal = ws("E5").DecimalValue

		' Output parsed values to the console
		Console.WriteLine("Parse B3 Cell Value into String: {0}", str_val)
		Console.WriteLine("Parse G3 Cell Value into Int32: {0}", int32_val)
		Console.WriteLine("Parse E5 Cell Value into decimal: {0}", decimal_val)

		Console.ReadKey()
	End Sub
End Class

$vbLabelText $csharpLabel

9. How to Parse Excel Data Into Numeric & Boolean Values

Now we move to how to parse Excel file data. First, we look at how to deal with numeric Excel data, and then how to parse it into our required format.

Reading CSV Files in C#: a Tutorial, Figure 8: Summary table for each data type Summary table for each data type

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Parse Excel cell value into string
        string str_val = ws["B3"].Value.ToString();

        // Parse Excel cell value into Int32
        Int32 int32_val = ws["G3"].Int32Value;

        // Parse Excel cell value into Decimal
        decimal decimal_val = ws["E5"].DecimalValue;

        // Output parsed values to the console
        Console.WriteLine("Parse B3 Cell Value into String: {0}", str_val);
        Console.WriteLine("Parse G3 Cell Value into Int32: {0}", int32_val);
        Console.WriteLine("Parse E5 Cell Value into decimal: {0}", decimal_val);

        Console.ReadKey();
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Parse Excel cell value into string
        string str_val = ws["B3"].Value.ToString();

        // Parse Excel cell value into Int32
        Int32 int32_val = ws["G3"].Int32Value;

        // Parse Excel cell value into Decimal
        decimal decimal_val = ws["E5"].DecimalValue;

        // Output parsed values to the console
        Console.WriteLine("Parse B3 Cell Value into String: {0}", str_val);
        Console.WriteLine("Parse G3 Cell Value into Int32: {0}", int32_val);
        Console.WriteLine("Parse E5 Cell Value into decimal: {0}", decimal_val);

        Console.ReadKey();
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Parse Excel cell value into string
		Dim str_val As String = ws("B3").Value.ToString()

		' Parse Excel cell value into Int32
		Dim int32_val As Int32 = ws("G3").Int32Value

		' Parse Excel cell value into Decimal
		Dim decimal_val As Decimal = ws("E5").DecimalValue

		' Output parsed values to the console
		Console.WriteLine("Parse B3 Cell Value into String: {0}", str_val)
		Console.WriteLine("Parse G3 Cell Value into Int32: {0}", int32_val)
		Console.WriteLine("Parse E5 Cell Value into decimal: {0}", decimal_val)

		Console.ReadKey()
	End Sub
End Class

$vbLabelText $csharpLabel

This code will display the following output:

Reading CSV Files in C#: a Tutorial, Figure 9: Console output with correct data type Console output with correct data type

And we can see the values of the Excel file sample.xlsx here:

Reading CSV Files in C#: a Tutorial, Figure 10: Display correct data type in Excel Display correct data type in Excel

To parse Excel file data into Boolean data type, IronXL provides the BoolValue function. It can be used as follows:

// Access a cell value as a boolean
bool Val = ws["Cell Address"].BoolValue;

// Access a cell value as a boolean
bool Val = ws["Cell Address"].BoolValue;

' Access a cell value as a boolean
Dim Val As Boolean = ws("Cell Address").BoolValue

$vbLabelText $csharpLabel

10. How to Parse Excel Files into C# Collections

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Convert a range into an array
        var array = ws["B6:F6"].ToArray();

        // Get the count of items in the array
        int item = array.Count();

        // Get the first item as a string
        string total_items = array[0].Value.ToString();

        // Output information about the array to the console
        Console.WriteLine("First item in the array: {0}", item);
        Console.WriteLine("Total items from B6 to F6: {0}", total_items);

        Console.ReadKey();
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Convert a range into an array
        var array = ws["B6:F6"].ToArray();

        // Get the count of items in the array
        int item = array.Count();

        // Get the first item as a string
        string total_items = array[0].Value.ToString();

        // Output information about the array to the console
        Console.WriteLine("First item in the array: {0}", item);
        Console.WriteLine("Total items from B6 to F6: {0}", total_items);

        Console.ReadKey();
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Convert a range into an array
		Dim array = ws("B6:F6").ToArray()

		' Get the count of items in the array
		Dim item As Integer = array.Count()

		' Get the first item as a string
		Dim total_items As String = array(0).Value.ToString()

		' Output information about the array to the console
		Console.WriteLine("First item in the array: {0}", item)
		Console.WriteLine("Total items from B6 to F6: {0}", total_items)

		Console.ReadKey()
	End Sub
End Class

$vbLabelText $csharpLabel

10.1 How to Parse an Excel `WorkSheet` into a DataTable

One excellent feature of IronXL is that we can easily convert a specific Excel WorkSheet into a DataTable. For this purpose, we can use the .ToDataTable() function of IronXL as follows:

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Parse Sheet1 of sample.xlsx file into DataTable
        // Setting 'true' makes the first row in Excel as the column names in DataTable
        DataTable dt = ws.ToDataTable(true);
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Parse Sheet1 of sample.xlsx file into DataTable
        // Setting 'true' makes the first row in Excel as the column names in DataTable
        DataTable dt = ws.ToDataTable(true);
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Parse Sheet1 of sample.xlsx file into DataTable
		' Setting 'true' makes the first row in Excel as the column names in DataTable
		Dim dt As DataTable = ws.ToDataTable(True)
	End Sub
End Class

$vbLabelText $csharpLabel

10.2 How to Parse an Excel File into a DataSet

If we want to parse a complete Excel file into a DataSet, then for this purpose we can use the .ToDataSet() function in IronXL.

class Program
{
    static void Main(string[] args)
    {
        // Load an entire workbook into a DataSet
        WorkBook wb = WorkBook.Load("sample.xlsx");

        // Convert workbook to DataSet
        DataSet ds = wb.ToDataSet();

        // We can also get a DataTable from the DataSet which corresponds to a WorkSheet
        DataTable dt = ds.Tables[0];
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load an entire workbook into a DataSet
        WorkBook wb = WorkBook.Load("sample.xlsx");

        // Convert workbook to DataSet
        DataSet ds = wb.ToDataSet();

        // We can also get a DataTable from the DataSet which corresponds to a WorkSheet
        DataTable dt = ds.Tables[0];
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load an entire workbook into a DataSet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")

		' Convert workbook to DataSet
		Dim ds As DataSet = wb.ToDataSet()

		' We can also get a DataTable from the DataSet which corresponds to a WorkSheet
		Dim dt As DataTable = ds.Tables(0)
	End Sub
End Class

$vbLabelText $csharpLabel

10.3 Reading Excel Data within a Specific Range

IronXL provides an intelligent method for reading Excel file data within a specific range. The range can be applied to both rows and columns.

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Get specified range values by loop
        foreach (var item in ws["B3:B8"])
        {
            Console.WriteLine("Value is: {0}", item);
        }
        Console.ReadKey();
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Get specified range values by loop
        foreach (var item in ws["B3:B8"])
        {
            Console.WriteLine("Value is: {0}", item);
        }
        Console.ReadKey();
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Get specified range values by loop
		For Each item In ws("B3:B8")
			Console.WriteLine("Value is: {0}", item)
		Next item
		Console.ReadKey()
	End Sub
End Class

$vbLabelText $csharpLabel

The above code displays the following output:

Reading CSV Files in C#: a Tutorial, Figure 11: Console output to access all values in range B3:B8 Console output to access all values in range B3:B8

And produces the Excel file sample.xlsx values:

Reading CSV Files in C#: a Tutorial, Figure 12: Data display from sample.xlsx Data display from sample.xlsx

Additionally, IronXL is also compatible with many Excel methods to interact with cells including styling and border, math functions, conditional formatting or creating charts from available data.

11. How to Read Boolean Data in an Excel File

In application development, we need to make decisions based on the Boolean data type in Excel files.

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Traverse a range and output boolean values
        foreach (var item in ws["G1:G10"])
        {
            Console.WriteLine("Condition is: {0}", item.BoolValue);
        }
        Console.ReadKey();
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("sample.xlsx");
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Traverse a range and output boolean values
        foreach (var item in ws["G1:G10"])
        {
            Console.WriteLine("Condition is: {0}", item.BoolValue);
        }
        Console.ReadKey();
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("sample.xlsx")
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Traverse a range and output boolean values
		For Each item In ws("G1:G10")
			Console.WriteLine("Condition is: {0}", item.BoolValue)
		Next item
		Console.ReadKey()
	End Sub
End Class

$vbLabelText $csharpLabel

From this, we get the output:

Reading CSV Files in C#: a Tutorial, Figure 13: Console output from getting Boolean Data Console output from getting Boolean Data

And the Excel file sample.xlsx with values from C1 to C10:

Reading CSV Files in C#: a Tutorial, Figure 14: Excel sample to compare with Console output Excel sample to compare with Console output

12. How to Read a Complete Excel WorkSheet

It is simple to read a complete Excel WorkSheet by using rows and columns indexes. For this purpose, we use two loops: one for traversing all rows, and the second for traversing all columns of a specific row. Then we can easily obtain all the cell values within the entire Excel WorkSheet.

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("Weather.xlsx"); // Your Excel File Name
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Traverse all rows of Excel WorkSheet
        for (int i = 0; i < ws.Rows.Count(); i++)
        {
            // Traverse all columns of specific Row
            for (int j = 0; j < ws.Columns.Count(); j++)
            {
                // Get the values
                string val = ws.Rows[i].Columns[j].Value.ToString();
                Console.WriteLine("Value of Row {0} and Column {1} is: {2}", i, j, val);
            }
        }
        Console.ReadKey();
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load the workbook and access a specific worksheet
        WorkBook wb = WorkBook.Load("Weather.xlsx"); // Your Excel File Name
        WorkSheet ws = wb.GetWorkSheet("Sheet1");

        // Traverse all rows of Excel WorkSheet
        for (int i = 0; i < ws.Rows.Count(); i++)
        {
            // Traverse all columns of specific Row
            for (int j = 0; j < ws.Columns.Count(); j++)
            {
                // Get the values
                string val = ws.Rows[i].Columns[j].Value.ToString();
                Console.WriteLine("Value of Row {0} and Column {1} is: {2}", i, j, val);
            }
        }
        Console.ReadKey();
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load the workbook and access a specific worksheet
		Dim wb As WorkBook = WorkBook.Load("Weather.xlsx") ' Your Excel File Name
		Dim ws As WorkSheet = wb.GetWorkSheet("Sheet1")

		' Traverse all rows of Excel WorkSheet
		For i As Integer = 0 To ws.Rows.Count() - 1
			' Traverse all columns of specific Row
			For j As Integer = 0 To ws.Columns.Count() - 1
				' Get the values
				Dim val As String = ws.Rows(i).Columns(j).Value.ToString()
				Console.WriteLine("Value of Row {0} and Column {1} is: {2}", i, j, val)
			Next j
		Next i
		Console.ReadKey()
	End Sub
End Class

$vbLabelText $csharpLabel

Reading CSV Files in C#: a Tutorial, Figure 15: Console output from reading all values Console output from reading all values

13. How to Read Excel Files without Interop

IronXL is an Excel Library for C# and .NET which allows developers to read and edit Excel data from XLS and XLSX Documents without using Microsoft.Office.Interop.Excel.

The API allows us to create, read, manipulate, save and export Excel files intuitively for:

.NET Framework 4.5+
.NET Core 2+
.NET Standard
Xamarin
Windows Mobile
Mono
& Azure Cloud Hosting
Blazor
.NET MAUI

Add the following namespaces:

using IronXL;
using System;
using System.Linq;

using IronXL;
using System;
using System.Linq;

Imports IronXL
Imports System
Imports System.Linq

$vbLabelText $csharpLabel

Now write the following code inside the main function.

class Program
{
    static void Main(string[] args)
    {
        // Load an Excel file and access the first worksheet
        WorkBook workbook = WorkBook.Load("Weather.xlsx");
        WorkSheet sheet = workbook.WorkSheets.First();

        // Select cells easily in Excel notation and return the calculated value
        int cellValue = sheet["A2"].IntValue;

        // Read from ranges of cells elegantly
        foreach (var cell in sheet["A2:A10"])
        {
            Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
        }
    }
}

class Program
{
    static void Main(string[] args)
    {
        // Load an Excel file and access the first worksheet
        WorkBook workbook = WorkBook.Load("Weather.xlsx");
        WorkSheet sheet = workbook.WorkSheets.First();

        // Select cells easily in Excel notation and return the calculated value
        int cellValue = sheet["A2"].IntValue;

        // Read from ranges of cells elegantly
        foreach (var cell in sheet["A2:A10"])
        {
            Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text);
        }
    }
}

Friend Class Program
	Shared Sub Main(ByVal args() As String)
		' Load an Excel file and access the first worksheet
		Dim workbook As WorkBook = WorkBook.Load("Weather.xlsx")
		Dim sheet As WorkSheet = workbook.WorkSheets.First()

		' Select cells easily in Excel notation and return the calculated value
		Dim cellValue As Integer = sheet("A2").IntValue

		' Read from ranges of cells elegantly
		For Each cell In sheet("A2:A10")
			Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
		Next cell
	End Sub
End Class

$vbLabelText $csharpLabel

Reading CSV Files in C#: a Tutorial, Figure 16: Console output from each cell Console output from each cell

IronXL also fully supports ASP.NET, MVC, Windows, macOS, Linux, iOS, and Android Mobile application development.

14. Conclusion and Iron XL Special Offer

In addition to CSV parsing in C#, IronXL converts CSV files to Excel with just two lines of code!

Using C# or VB.NET, it is very easy to use IronXL's Excel API without the need for Interop. You can read, edit, and create Excel spreadsheets or work with other Excel formats such as XLS/XLSX/CSV/TSV. With the support of multiple frameworks, you can buy 5 products for the price of two. Click on our pricing page for further information.

Reading CSV Files in C#: a Tutorial, Figure 17: 5 products of Iron Suite 5 products of Iron Suite

常见问题解答

我如何在 C# 中读取 CSV 文件？

要在 C# 中读取 CSV 文件，您可以通过在 Visual Studio 中通过 NuGet 安装 IronXL 来使用该库。安装后，使用 WorkBook.LoadCSV 方法来加载和解释 CSV 文件。

什么是 CSV？为什么在 C# 中处理会变得复杂？

CSV 是一种简单的数据格式，但由于分隔符的变化，处理起来可能很复杂。IronXL 简化了 C# 项目中 CSV 文件的读取和解析。

我可以使用 C# 将 CSV 文件转换为 Excel 吗？

可以，IronXL 允许您通过加载 CSV 并使用 WorkBook.SaveAs 方法保存来将 CSV 文件转换为 XLS 或 XLSX 等 Excel 格式。

如何在 C# 项目中安装 IronXL？

您可以通过在 Visual Studio 中使用 NuGet 包管理器安装 IronXL。搜索 'IronXL.Excel' 并将其添加到您的项目中，以开始处理 Excel 文件。

是否可以在 C# 中将 Excel 单元格数据解析为特定数据类型？

可以，使用 IronXL，您可以使用 Int32Value 和 BoolValue 等方法将 Excel 单元格值解析为数值和布尔等特定数据类型。

如何在 C# 中读取 Excel 工作表中特定范围内的单元格数据？

使用 IronXL，您可以通过循环迭代范围并通过 IronXL 的索引功能访问单元格值来读取特定单元格的数据。

如何在 C# 中将 Excel 工作表转换为 DataTable？

您可以使用 IronXL 的 WorkSheet.ToDataTable 方法将 Excel 工作表转换为 DataTable，该方法可高效地将工作表解析为 DataTable 对象以供数据操作。

我需要 Microsoft Office Interop 来以编程方式读取 Excel 文件吗？

不，使用 IronXL，您无需 Microsoft Office Interop 即可读取和操作 Excel 文件，使其成为独立且高效的解决方案。

使用 IronXL 处理 Excel 和 CSV 文件的优势是什么？

IronXL 提供简单的安装，无需依赖 Interop，支持多种 Excel 格式，并且与各种 .NET 框架兼容，从而提高处理 CSV 和 Excel 文件的生产力。

如何在 C# 中读取完整的 Excel 工作表？

要使用 IronXL 读取完整的 Excel 工作表，您可以使用嵌套循环遍历所有行和列，并使用 IronXL 的方法提取单元格值。

Curtis Chau

立即与工程团队聊天

技术作家

Curtis Chau 拥有卡尔顿大学的计算机科学学士学位，专注于前端开发，精通 Node.js、TypeScript、JavaScript 和 React。他热衷于打造直观且美观的用户界面，喜欢使用现代框架并创建结构良好、视觉吸引力强的手册。

除了开发之外，Curtis 对物联网 (IoT) 有浓厚的兴趣，探索将硬件和软件集成的新方法。在空闲时间，他喜欢玩游戏和构建 Discord 机器人，将他对技术的热爱与创造力相结合。

已发布十月 27, 2025

如何在 C# 中创建 Excel 数据透视表

学习通过这个清晰的分步指南使用C# Interop和IronXL在Excel中创建数据透视表。

已发布十月 27, 2025

如何在C#中将DataGridView导出到包含列头的Excel

学习如何在将DataGridView数据导出到Excel时保留列头。使用IronXL库的C#逐步教程。

已发布十月 27, 2025

如何在.NET Core中使用CSV Reader与IronXL

学习通过实际示例有效地使用IronXL作为.NET Core的CSV读取器。

如何在 Excel 中突出显示每隔一行

如何在 Excel 中锁定单元格�...

客户亮点：

开发者焦点：

网络研讨会：

在 C# 中读取 CSV 文件：教程

What is CSV?

1. How to read a CSV File in C#

2. IronXL for Excel Files

3. Load `WorkBook` and Access `WorkSheet`

4. Reading an Excel WorkSheet as a DataTable

5. CSV parsing in C# .NET

6. Reading CSV Data in C# Records

7. Getting Data from Excel Files

8. How to Parse Excel Files in C#

9. How to Parse Excel Data Into Numeric & Boolean Values

10. How to Parse Excel Files into C# Collections

10.1 How to Parse an Excel `WorkSheet` into a DataTable

10.2 How to Parse an Excel File into a DataSet

10.3 Reading Excel Data within a Specific Range

11. How to Read Boolean Data in an Excel File

12. How to Read a Complete Excel WorkSheet

13. How to Read Excel Files without Interop

14. Conclusion and Iron XL Special Offer

常见问题解答

我如何在 C# 中读取 CSV 文件？

什么是 CSV？为什么在 C# 中处理会变得复杂？

我可以使用 C# 将 CSV 文件转换为 Excel 吗？

如何在 C# 项目中安装 IronXL？

是否可以在 C# 中将 Excel 单元格数据解析为特定数据类型？

如何在 C# 中读取 Excel 工作表中特定范围内的单元格数据？

如何在 C# 中将 Excel 工作表转换为 DataTable？

我需要 Microsoft Office Interop 来以编程方式读取 Excel 文件吗？

使用 IronXL 处理 Excel 和 CSV 文件的优势是什么？

如何在 C# 中读取完整的 Excel 工作表？

在 C# 中读取 CSV 文件：教程

What is CSV?

1. How to read a CSV File in C#

2. IronXL for Excel Files

3. Load WorkBook and Access WorkSheet

4. Reading an Excel WorkSheet as a DataTable

5. CSV parsing in C# .NET

6. Reading CSV Data in C# Records

7. Getting Data from Excel Files

8. How to Parse Excel Files in C#

9. How to Parse Excel Data Into Numeric & Boolean Values

10. How to Parse Excel Files into C# Collections

10.1 How to Parse an Excel WorkSheet into a DataTable

10.2 How to Parse an Excel File into a DataSet

10.3 Reading Excel Data within a Specific Range

11. How to Read Boolean Data in an Excel File

12. How to Read a Complete Excel WorkSheet

13. How to Read Excel Files without Interop

14. Conclusion and Iron XL Special Offer

常见问题解答

我如何在 C# 中读取 CSV 文件？

什么是 CSV？为什么在 C# 中处理会变得复杂？

我可以使用 C# 将 CSV 文件转换为 Excel 吗？

如何在 C# 项目中安装 IronXL？

是否可以在 C# 中将 Excel 单元格数据解析为特定数据类型？

如何在 C# 中读取 Excel 工作表中特定范围内的单元格数据？

如何在 C# 中将 Excel 工作表转换为 DataTable？

我需要 Microsoft Office Interop 来以编程方式读取 Excel 文件吗？

使用 IronXL 处理 Excel 和 CSV 文件的优势是什么？

如何在 C# 中读取完整的 Excel 工作表？

相关文章

如何在 C# 中创建 Excel 数据透视表

如何在C#中将DataGridView导出到包含列头的Excel

如何在.NET Core中使用CSV Reader与IronXL

免费获取

下一步：开始免费 30 天试用

下一步：开始免费 30 天试用

深受全球 200 多万工程师信赖

3. Load `WorkBook` and Access `WorkSheet`

10.1 How to Parse an Excel `WorkSheet` into a DataTable