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

How to read CSV Files in C#

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

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

在NuGet包管理器中安装IronXL包

IronXL是在C#中读取CSV文件时一个很好的工具。 下面的代码示例显示您可以使用逗号或其他分隔符读取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");

本教程的CSV数据

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

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

数据转换为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();
}

从CSV文件访问数据并显示在控制台中

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

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

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

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

结论和IronXL特别优惠

除了在C#中处理CSV外，IronXL还可以通过两行代码将CSV转换为Excel。

使用IronXL的Excel API是一种无需互操作的简单方法。 此外，IronXL还提供了丰富的功能，可以与Excel工作簿、工作表和单元级别进行交互，例如在流行格式之间转换，单元格数据格式化，合并单元格，插入数学函数， 甚至管理图表和添加图像。

您可以使用IronXL试用许可密钥启动而不带水印。

许可证起价为$799，并包括一年的免费支持和更新。

IronPDF、IronXL、IronOCR、IronBarcode和IronWebscraper都是Iron Software套件的一部分。 Iron Software允许您以更低的价格购买其整个软件包。您可以以两种价格使用所有这些工具。

这绝对是一个值得探索的选项。