csv文件中有行字符串中有,的读取方法

public static DataTable Csv2DataSet(string fileFullPath)
        {
            int intColCount = 0;
            bool blnFlag = true;
            DataTable mydt = new DataTable("myTableName");
            DataColumn mydc;
            DataRow mydr;
            string strpath = fileFullPath; //cvs文件路径
            string strline;
            string[] aryline;

            System.IO.StreamReader mysr = new System.IO.StreamReader(strpath, Encoding.Default);
            while ((strline = mysr.ReadLine()) != null)
            {
                aryline = strToAry(strline);
                if (blnFlag)
                {
                    blnFlag = false;
                    intColCount = aryline.Length;
                    for (int i = 0; i < aryline.Length; i++)
                    {
                        mydc = new DataColumn(aryline[i]);
                        mydt.Columns.Add(mydc);
                    }
                }
                mydr = mydt.NewRow();
                for (int i = 0; i < intColCount; i++)
                {
                    mydr[i] = aryline[i];
                }
                mydt.Rows.Add(mydr);
            }
            return mydt;
        }
        private static string[] strToAry(string strLine)
        {
            string strItem = "";
            int iFenHao = 0;
            System.Collections.ArrayList lstStr = new System.Collections.ArrayList();

            for (int i = 0; i < strLine.Length; i++)
            {
                string strA = strLine.Substring(i, 1);

                if (strA == "\"")
                {
                    iFenHao = iFenHao + 1;
                }

                if (iFenHao == 2)
                {
                    iFenHao = 0;
                }

                if (strA == "," && iFenHao == 0)
                {
                    lstStr.Add(strItem);
                    strItem = "";
                }
                else
                {
                    strItem = strItem + strA;
                }
            }

            if (strItem.Length > 0)
                lstStr.Add(strItem);

            return (String[])lstStr.ToArray(typeof(string));
        }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值