/// <summary>

        /// 读取Excel表每一行第一列的字符串集合

        /// </summary>

        /// <param name="filePath">文件路径</param>

        /// <returns></returns>

        private string[] ExcelReader(string filePath)

        {

            List<string> result = new List<string>();

            string connStr = "Provider=Microsoft.Ace.OleDb.12.0;data source=" + filePath + ";Extended Properties='Excel 12.0; HDR=NO; IMEX=1'";

            OleDbConnection Conn = new OleDbConnection(connStr);

            Conn.Open();

            DataTable dtTabeName = new DataTable();

            dtTabeName = Conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

            if (dtTabeName == null)

            {

                return null;

            }

            string SheetName = dtTabeName.Rows[]["TABLE_NAME"].ToString();

            DataSet ds = new DataSet();

            OleDbDataAdapter odda = null;

            odda = new OleDbDataAdapter(string.Format("SELECT * FROM [{0}]", SheetName), Conn);

            odda.Fill(ds, SheetName);

            Conn.Close();

            DataTable dt = ds.Tables[];

            for (int i = ; i < dt.Rows.Count; i++)

            {

                if (dt.Rows[i][].ToString().Trim().Length > )

                {

                    result.Add(dt.Rows[i][].ToString());

                }

            }

            return result.ToArray();

        }

        /// <summary>

        /// 读取Csv\Txt文件中每一行第一列的字符串集合

        /// </summary>

        /// <param name="filePath">文件路径</param>

        /// <param name="encoding">编码</param>

        /// <returns></returns>

        private string[] CsvTxtReader(string filePath, string encoding = "gb2312")

        {

            StringBuilder sb = new StringBuilder();

            using (StreamReader sr = new StreamReader(filePath, Encoding.GetEncoding(encoding)))

            {

                sb.Append(sr.ReadToEnd());

            }

            string _text = sb.ToString();

            string[] separator = { "\r\n", "\n\r", "\n" };

            string[] _textArray = _text.Split(separator, StringSplitOptions.RemoveEmptyEntries);

            return _textArray;

        }