DataGridView 导入数据 →将Excel中数据导入到DataTable

public class ExcelToDataTable
    {
        #region 将Excel中数据导入到DataTable，excel充当数据库

        public static DataTable ImportExcel(string path)
        {
            string Connecstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path
                + ";Extended Properties='Excel 8.0;HDR=YES; IMEX=1'";
            OleDbConnection Con = new OleDbConnection(Connecstr);
            Con.Open();
            string strCommand = "SELECT   *   FROM   [Sheet1$]";
            OleDbDataAdapter adapter = new OleDbDataAdapter(strCommand, Con);
            DataSet DS = new DataSet();
            adapter.Fill(DS, "[Sheet1$]");
            DataTable dt = DS.Tables[0];
            Con.Close();
            return dt;
        }

        #endregion
    }