前提条件：本机需支持office编程，如不支持，需执行修复，在安装那里选择支持开发模式

String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties=Excel 8.0;";  //关键是这句            try            {                OleDbConnection objConn = new OleDbConnection(sConnectionString);                objConn.Open();                OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);                //$sheet1是excel文档中的工作表名称，默认都是sheet1、sheet2……                //把代码中的sheet1改称你的excel文档中工作表的名称吧。                OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();                objAdapter1.SelectCommand = objCmdSelect;               DataSet objDataset1 = new DataSet();                           // objAdapter1.Fill(ds, "XLData");              // ds = objDataset1;               DataTable dt = new DataTable();               DataColumn dc = new DataColumn("abc");               dc.DataType = typeof(bool);               dc.AllowDBNull = false;               dc.DefaultValue = false;               dt.Columns.Add(dc);               objAdapter1.Fill(dt);             //   dataGridView1.DataSource = objDataset1.Tables[0].DefaultView;               dataGridView1.DataSource = dt;                objConn.Close();            }            catch (Exception ex)            {                MessageBox.Show(ex.Message.ToString());            }