导入CSV格式文件方法

最新推荐文章于 2023-07-20 20:55:30 发布

aut8184

最新推荐文章于 2023-07-20 20:55:30 发布

阅读量323

点赞数

原文链接：http://www.cnblogs.com/zhoumingxiu/p/3312030.html

版权

  /// <summary>
        /// 导入CSV格式文件
        /// </summary>
        /// <param name="filePath">文件地址</param>
        /// <returns></returns>
protected DataTable GetFlowData(string filePath)
        {
            string strline;
            string[] aryline;
            bool blnFlag = true;
            DataTable dt = new DataTable();

            StreamReader mysr = new StreamReader(filePath, System.Text.Encoding.Default);
            try
            {
                int ColCount = 0;
                while ((strline = mysr.ReadLine()) != null)
                {

                    aryline = strline.Split(new char[] { ',' });
                    if (blnFlag)
                    {
                        blnFlag = false;
                        ColCount = aryline.Length;
                        for (int i = 0; i < aryline.Length; i++)
                        {
                            dt.Columns.Add(aryline[i]);
                        }
                        continue;
                    }
                    DataRow dr = dt.NewRow();
                    for (int i = 0; i < ColCount; i++)
                    {
                        dr[i] = aryline[i];
                    }
                    dt.Rows.Add(dr);

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                mysr.Close();
                mysr.Dispose();
            }
            return dt;
        }