string table0 = textBox1.Text.Trim();
                //string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source ="+table0+";Extended Properties=Excel 8.0";
                string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + table0 + ";Extended Properties=\"Excel 8.0; HDR = No;IMEX=1\"" ;
                OleDbConnection myConn = new OleDbConnection(strCon);
                string strCom = " SELECT * FROM [sheet1$] ";
                myConn.Open();
                //打开数据链接，得到一个数据集
                OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
                //创建一个 DataSet对象
                //myDataSet = new DataSet();
                DataSet myDataSet = new DataSet();
                //得到自己的DataSet对象
                myCommand.Fill(myDataSet, "[sheet1$]");
                //数据绑定

                string adf1=myDataSet .Tables ["sheet1$"].Rows[2][5].ToString();


这样读取不了数据，为什么？

调用Microsoft Excel自动化对象模型的Workbooks对象的Add()方法，创建一个新的工作薄，然后通过设置Excel对象的Cells属性，向新建的工作薄中添加数据记录。
private void button1_Click(objiect sender,EventArgs e)
{
ExportDataGridview(dataGridView1,true);
}

public booExportDataGridview(DataGridView dgv,bool isShowExcle)
{
  if(dgv.Rows.Count == 0)
    return false;
//建立EXCEL对象
    Excel.Application excel = new Exel.Application();
    excel.Application.Workbooks.Add(true);
    excel.Visible = isShowExcel;
//生成字段名称
for(int i=0;i<dgv.ColumnCount;i++)
{
excel.Cells[1,i_1] = dgv.Columns[i].HeaderText;
}
//填充数据
for(int i=0;i<dgv.RowCount-1;i++)
 {
   for(int j=0;j<dgv.CounmnCount;j++)
 {
   if(dgv[j,i].ValueType == typeof(string))
   {
     excel.Cells[i+2,j+1]=""+dgv[j,i].Value.ToString();
   }
  else
   {
     excel.Cells[i+2,j+1]=dgv[j,i].Value.ToString();
   }  
 }
}
return true
}
希望能帮到你！有空一起交流！412906819（技术交流）

、阿什顿

  private DataSet ExcelToDataSet(string opnFileName)
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + opnFileName + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";
            OleDbConnection conn = new OleDbConnection(strConn);
            string strExcel = "";
            OleDbDataAdapter myCommand = null;
            DataSet ds = new DataSet();
            strExcel = "select * from [" + textBox6.Text + "$]";
            try
            {
                conn.Open();
                myCommand = new OleDbDataAdapter(strExcel, strConn);
                myCommand.Fill(ds, "Sheet1");
                return ds;
            }
            catch (Exception ex)
            {
                MessageBox.Show("导入出错：" + ex, "错误信息");
                return ds;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
            }

        }

                        DataSet ds = ExcelToDataSet();
                        DataTable table = ds.Tables["Sheet1"];
                        foreach (DataRow dt in ds.Tables["Sheet1"].Rows)
                        {
                            string start = dt[0].ToString();
                            if (start == textBox1.Text) //这句是如果你输入的到文本框中的数据等于Excel表格中就进行下面的读取数据操作
                            {
                                string s = dt[0].ToString();
                                string jo = dt[1].ToString();
                                string jol = dt[2].ToString();
                                break;
                            }
                        }

非常感谢