C#的CSV解析器/读取器?[关闭]

FileHelpers Open Source Library .

CodeProject

static DataTable CsvToDataTable(string strFileName)
{
    DataTable dataTable = new DataTable("DataTable Name");

    using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + Directory.GetCurrentDirectory() + "; Extended Properties = \"Text;HDR=YES;FMT=Delimited\""))
    {
        conn.Open();
        string strQuery = "SELECT * FROM [" + strFileName + "]";
        OleDbDataAdapter adapter = 
            new System.Data.OleDb.OleDbDataAdapter(strQuery, conn);
        adapter.Fill(dataTable);
    }
    return dataTable;
}

filehelpers 工作得非常好。我每天都用它来解析一个100 MB的文件。

你试过FileHelpers库吗?它是免费的、开源的,可用于解析CSV文件。

• http://www.filehelpers.net/

我已经开始使用CSV解析器,它是 CommonLibrary.NET .