前提条件：本机需支持office编程，如不支持 ， 需执行修复，在安装那里选择支持开发模式
【excel怎么加文档 excel文档导入DataGird】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 = https://www.itzhengshu.com/excel/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());}