获取excel文件数据

        //获取excel文件数据
        private static List<string> GetReSendData(string fileFullPath)
        {
            DataTable dtData = null;
            string strConn = @"Provider=Microsoft.Ace.OleDb.12.0;" + "data source=" + fileFullPath + ";Extended Properties='Excel 12.0; HDR=NO; IMEX=1'";
            using (OleDbConnection conn = new OleDbConnection(strConn))
            {
                conn.Open();
                DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
                string tableName = dt.Rows[0][2].ToString().Trim();
                DataSet ds = new DataSet();
                OleDbDataAdapter odda = new OleDbDataAdapter("SELECT * FROM [" + tableName + "]", conn);
                odda.Fill(ds, "table1");
                dtData = ds.Tables[0];
            }
            return ConvertToList(dtData);
        }

        private static List<string> ConvertToList(DataTable dt)
        {
            var list = new List<string>();
            if (dt == null || dt.Rows.Count == 0)
                return list;
            DataTable dt2 = dt.DefaultView.ToTable(true, dt.Columns[0].ColumnName);
            foreach (DataRow row in dt2.Rows)
            {
                var contractno = row[0];
                if (contractno == null || string.IsNullOrWhiteSpace(contractno.ToString()))
                {
                    continue;
                }
                list.Add(contractno.ToString().Trim());
            }
            return list;
        }