CSV文件转DataTable

CSV文件转DataTable

public DataTable CsvToDataTable(string vFilePath)
{
    DataTable dataTable = new DataTable();
    try
    {
        TextFieldParser textFieldParser = new TextFieldParser(vFilePath, Encoding.UTF8);
        textFieldParser.SetDelimiters(new string[]
        {
            ","
        });
        textFieldParser.HasFieldsEnclosedInQuotes = true;
        string[] array = textFieldParser.ReadFields();
        foreach (string text in array)
        {
            DataColumn dataColumn = new DataColumn();
            dataColumn.AllowDBNull = true;
            if (!string.IsNullOrEmpty(text))
            {
                dataColumn.ColumnName = text;
            }
            dataTable.Columns.Add(dataColumn);
        }
        while (!textFieldParser.EndOfData)
        {
            string[] array3 = textFieldParser.ReadFields();
            for (int j = 0; j < array3.Length; j++)
            {
                if (array3[j] == "")
                {
                    array3[j] = null;
                }
            }
            dataTable.Rows.Add(array3);
        }
        textFieldParser.Close();
    }
    catch (Exception ex)
    {
        throw new Exception("Csv to DataTable : \n" + ex.Message);
    }
    return dataTable;
}      

本文来自博客园，作者：農碼一生，转载请注明原文链接：https://www.cnblogs.com/wml-it/p/14731074.html

技术的发展日新月异，随着时间推移，无法保证本博客所有内容的正确性。如有误导，请大家见谅，欢迎评论区指正！ 个人开源代码链接: GitHub:

https://github.com/ITMingliang

Gitee:

https://gitee.com/mingliang_it

GitLab:

https://gitlab.com/ITMingliang

进开发学习交流群：