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

您可以使用IronXL库在C#中读取CSV文件，使用 LoadCSV 方法，这允许您将CSV数据加载到 WorkBook 对象中以进行进一步操作。

在 C# 中将 CSV 数据转换为 Excel 格式的最佳方法是什么？

在C#中将CSV数据转换为Excel格式的最佳方法是使用IronXL。将您的CSV加载到 WorkBook 对象中，使用 SaveAs 方法将其保存为Excel文件。

如何使用库在 C# 中处理具有自定义分隔符的 CSV 文件？

使用IronXL，您可以通过在 LoadCSV 方法中将分隔符指定为可选参数来处理具有自定义分隔符的CSV文件。

我可以直接将 CSV 数据转换为 C# 中的数据库格式吗？

是的，您可以使用IronXL在C#中将CSV数据转换为数据库格式，利用 ToDataTable 方法将数据转换为适合数据库操作的DataTable对象。

在 C# 中有哪些方法可以检查不存在的 CSV 文件？

在C#中，您可以使用IronXL的 Exists 方法在尝试加载CSV文件之前检查CSV文件是否存在，从而避免与不存在的文件相关的错误。

在使用 C# 从 CSV 转换为 Excel 后，如何操作 Excel 数据？

在 C# 中将 CSV 转换为 Excel 后，您可以使用 IronXL 的功能来操作数据，例如格式化、合并单元格、插入数学函数以及添加图表或图像。

IronXL 读取和转换 C# 中 CSV 文件有哪些优势？

IronXL 提供的优势包括易于安装、无需额外的互操作、支持自定义分隔符，以及在 Excel 中转换和操作 CSV 数据的强大方法。

如何在 C# 中处理 CSV 数据中的特殊字符？

IronXL 可以通过允许您在加载 CSV 文件时指定文件编码和分隔符来处理 CSV 数据中的特殊字符，以确保数据的完整性和准确性。

IronXL 用户可获得哪些支持？

IronXL 许可证包括一年免费支持和更新，提供帮助并确保您获得最新的功能和修复。

What does IronXL offer in terms of licensing and support?

IronXL offers licensing options starting at $liteLicense, which include one year of free support and updates. Trial licenses allow evaluation without watermarks.

C# Excel库

Explore IronXL Excel电子表格库用于C# .NET 免费试用

无须互操作读取Excel文件

查看所有%s代码示例

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);

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);

PM >Install-Package IronXL.Excel

Install-Package IronXL.Excel

USING IRONXL

using C# 读取 CSV 文件（代码示例教程）

Curtis Chau

Updated: 2026年6月28日

本教程演示了如何使用IronXL C#库在不安装其他互操作的情况下高效、有效地读取CSV文件。

如何在 C# 中逐行读取 CSV 文件

安装 C# 库以逐行读取 CSV 文件
利用高级LoadCSV方法读取CSV文件
使用C#中的Exists方法捕获加载不存在的文件
使用ToDataTable方法将 CSV 数据转换为数据库。
使用SaveAs方法导出 Excel 文件，CSV 数据会自动转换为 Excel 文件。

How to read CSV Files in C#

您必须先安装IronXL，才能在MVC、ASP.NET或.NET Core中使用它读取CSV文件。这是该过程的基本概述。

在Visual Studio中选择项目菜单，管理NuGet包，搜索IronXL.Excel，然后安装。

使用C#读取CSV文件（代码示例教程），图1：在NuGet包管理器中安装IronXL包 在NuGet包管理器中安装IronXL包

当您需要在C#中读取CSV文件时，IronXL是一个出色的工具。下面的代码示例显示您可以使用逗号或其他分隔符读取CSV文件。

// Load a CSV file into a WorkBook object specifying file format and delimiters
WorkBook workbook = WorkBook.LoadCSV("Weather.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

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

// Save the workbook as an Excel file
workbook.SaveAs("Csv_To_Excel.xlsx");

// Load a CSV file into a WorkBook object specifying file format and delimiters
WorkBook workbook = WorkBook.LoadCSV("Weather.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

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

// Save the workbook as an Excel file
workbook.SaveAs("Csv_To_Excel.xlsx");

' Load a CSV file into a WorkBook object specifying file format and delimiters
Dim workbook As WorkBook = WorkBook.LoadCSV("Weather.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")

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

' Save the workbook as an Excel file
workbook.SaveAs("Csv_To_Excel.xlsx")

' Load a CSV file into a WorkBook object specifying file format and delimiters
Dim workbook As WorkBook = WorkBook.LoadCSV("Weather.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")

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

' Save the workbook as an Excel file
workbook.SaveAs("Csv_To_Excel.xlsx")

使用C#读取CSV文件（代码示例教程），图2：本教程的CSV数据 本教程的CSV数据

对象WorkBook已创建。然后使用WorkBook对象的LoadCSV方法来指示CSV文件的名称、格式以及读取的CSV文件中使用的分隔符，并将它们存储为字符串数组。在此场景中使用逗号作为分隔符。

之后，创建一个WorkSheet对象；这就是CSV文件内容将被存储的地方。然后将文件重命名并存储为新格式。然后，CSV文件数据在工作表中以表格形式排列。输出将如下所示：

使用C#读取CSV文件（代码示例教程），图3：数据转换为Excel文件 数据转换为Excel文件

CSV parsing in C# .NET

CSV在处理字段中的换行符和字段可能被引号括起时存在几个问题，这阻止了简单的字符串分割技术的应用Split("'")。相反，IronXL通过LoadCSV方法提供可选参数自定义分隔符，查看LoadCSV的API文档获取更多详细信息。

C# Records — Reading CSV Data

在下面的示例中，foreach循环用于迭代CSV文件中的行，使用Console写入记录中的数据。

// Load a CSV file into a WorkBook object specifying file format and delimiters
WorkBook workbook = WorkBook.LoadCSV("Weather.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

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

// Convert the worksheet data into a DataTable
DataTable dt = ws.ToDataTable(true); // The argument true indicates the first row is header

// Iterate through each row in the DataTable
foreach (DataRow row in dt.Rows)
{
    // Iterate through each column in the current row
    for (int i = 0; i < dt.Columns.Count; i++)
    {
        // Output each cell value to the console
        Console.Write(row[i] + "  ");
    }
    // New line after each row
    Console.WriteLine();
}

// Load a CSV file into a WorkBook object specifying file format and delimiters
WorkBook workbook = WorkBook.LoadCSV("Weather.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

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

// Convert the worksheet data into a DataTable
DataTable dt = ws.ToDataTable(true); // The argument true indicates the first row is header

// Iterate through each row in the DataTable
foreach (DataRow row in dt.Rows)
{
    // Iterate through each column in the current row
    for (int i = 0; i < dt.Columns.Count; i++)
    {
        // Output each cell value to the console
        Console.Write(row[i] + "  ");
    }
    // New line after each row
    Console.WriteLine();
}

' Load a CSV file into a WorkBook object specifying file format and delimiters
Dim workbook As WorkBook = WorkBook.LoadCSV("Weather.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")

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

' Convert the worksheet data into a DataTable
Dim dt As DataTable = ws.ToDataTable(True) ' The argument true indicates the first row is header

' Iterate through each row in the DataTable
For Each row As DataRow In dt.Rows
	' Iterate through each column in the current row
	For i As Integer = 0 To dt.Columns.Count - 1
		' Output each cell value to the console
		Console.Write(row(i) & "  ")
	Next i
	' New line after each row
	Console.WriteLine()
Next row

' Load a CSV file into a WorkBook object specifying file format and delimiters
Dim workbook As WorkBook = WorkBook.LoadCSV("Weather.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")

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

' Convert the worksheet data into a DataTable
Dim dt As DataTable = ws.ToDataTable(True) ' The argument true indicates the first row is header

' Iterate through each row in the DataTable
For Each row As DataRow In dt.Rows
	' Iterate through each column in the current row
	For i As Integer = 0 To dt.Columns.Count - 1
		' Output each cell value to the console
		Console.Write(row(i) & "  ")
	Next i
	' New line after each row
	Console.WriteLine()
Next row

使用C#读取CSV文件（代码示例教程），图4：从CSV文件访问数据并显示到Console 从CSV文件访问数据并显示在控制台中

将CSV文件字符串行转换为Excel格式

过程很简单：加载CSV文件并将其保存为Excel文件。

// Load a CSV file into a WorkBook object specifying file format and delimiters
WorkBook workbook = WorkBook.LoadCSV("test.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

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

// Save the workbook as an Excel file
workbook.SaveAs("CsvToExcelConversion.xlsx");

// Load a CSV file into a WorkBook object specifying file format and delimiters
WorkBook workbook = WorkBook.LoadCSV("test.csv", fileFormat: ExcelFileFormat.XLSX, ListDelimiter: ",");

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

// Save the workbook as an Excel file
workbook.SaveAs("CsvToExcelConversion.xlsx");

' Load a CSV file into a WorkBook object specifying file format and delimiters
Dim workbook As WorkBook = WorkBook.LoadCSV("test.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")

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

' Save the workbook as an Excel file
workbook.SaveAs("CsvToExcelConversion.xlsx")

' Load a CSV file into a WorkBook object specifying file format and delimiters
Dim workbook As WorkBook = WorkBook.LoadCSV("test.csv", fileFormat:= ExcelFileFormat.XLSX, ListDelimiter:= ",")

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

' Save the workbook as an Excel file
workbook.SaveAs("CsvToExcelConversion.xlsx")

使用IronXL读取和操作转换后的CSV文件

IronXL WorkBook类表示一个Excel工作表，并使用此类在C#中打开Excel文件。下面的代码示例将所需的Excel文件加载到WorkBook对象中：

// Load WorkBook from a .xlsx file
var workbook = WorkBook.Load(@"Spreadsheets\\sample.xlsx");

// Load WorkBook from a .xlsx file
var workbook = WorkBook.Load(@"Spreadsheets\\sample.xlsx");

' Load WorkBook from a .xlsx file
Dim workbook = WorkBook.Load("Spreadsheets\\sample.xlsx")

' Load WorkBook from a .xlsx file
Dim workbook = WorkBook.Load("Spreadsheets\\sample.xlsx")

WorkSheet对象可以在许多WorkBooks中找到。这些是Excel文档的工作表。如果工作簿有工作表，可以通过以下方法按名称获取它们：

// Open a specific worksheet for reading by its name
var worksheet = workbook.GetWorkSheet("sheetnamegoeshere");

// Open a specific worksheet for reading by its name
var worksheet = workbook.GetWorkSheet("sheetnamegoeshere");

' Open a specific worksheet for reading by its name
Dim worksheet = workbook.GetWorkSheet("sheetnamegoeshere")

' Open a specific worksheet for reading by its name
Dim worksheet = workbook.GetWorkSheet("sheetnamegoeshere")

读取单元格值的代码：

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

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

' Read and output values from a range of cells elegantly
For Each cell In worksheet("A2:A10")
	Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
Next cell

' Read and output values from a range of cells elegantly
For Each cell In worksheet("A2:A10")
	Console.WriteLine("Cell {0} has value '{1}'", cell.AddressString, cell.Text)
Next cell

下面的代码示例可以在加载和读取工作簿和工作表后更新公式或将它们应用于特定单元格。以下是代码：

// Set formulas for specific cells
worksheet["A1"].Formula = "Sum(B8:C12)";
worksheet["B8"].Formula = "=C9/C11";
worksheet["G30"].Formula = "Max(C3:C7)";

// Force recalculate all formula values in all sheets
workbook.EvaluateAll();

// Set formulas for specific cells
worksheet["A1"].Formula = "Sum(B8:C12)";
worksheet["B8"].Formula = "=C9/C11";
worksheet["G30"].Formula = "Max(C3:C7)";

// Force recalculate all formula values in all sheets
workbook.EvaluateAll();

' Set formulas for specific cells
worksheet("A1").Formula = "Sum(B8:C12)"
worksheet("B8").Formula = "=C9/C11"
worksheet("G30").Formula = "Max(C3:C7)"

' Force recalculate all formula values in all sheets
workbook.EvaluateAll()

' Set formulas for specific cells
worksheet("A1").Formula = "Sum(B8:C12)"
worksheet("B8").Formula = "=C9/C11"
worksheet("G30").Formula = "Max(C3:C7)"

' Force recalculate all formula values in all sheets
workbook.EvaluateAll()