操作csv的代码示例

偶遇的一段代码，收藏下来。

        /// <summary>
        /// Creates and returns a DataTable for the specified CSV file in the specified directory
        /// NOTE: The file must not be in use by another process
        /// </summary>
        /// <param name="csvDirectory">The directory in which the CSV file is located</param>
        /// <param name="csvFileName">The name of the CSV file</param>
        /// <returns>A DataTable of the CSV file</returns>
        public static DataTable GetDataTableForCsv(string csvDirectory, string csvFileName)
        {
            // Open a connect to the file via ODBC
            OdbcConnection dbConn = new OdbcConnection("Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=" + csvDirectory + ";");
            dbConn.Open();

            // Construct the Database Name in ODBC format
            string dbName = "[" + csvFileName + "]";

            // Get everything from the file
            string sql = @"SELECT * FROM " + dbName;

            // Get the data
            OdbcDataAdapter dbCmd = new OdbcDataAdapter(sql, dbConn);
            DataSet dataSet = new DataSet(dbName);
            dbCmd.Fill(dataSet, dbName);
            dbConn.Close();

            // Return the data
            return dataSet.Tables[0];
        }

 调用示例：

            // Get the list of leads
            DataTable leads = GetDataTableForCsv("C:\\Extending\\Ch3", "Leads.csv");