读取EXCEL文件内容

private void button1_Click(object sender, System.EventArgs e)
  {//读取EXCEL文件内容
   try
   {
    string strConnection="";
    strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" +
     "Data Source=MyExcel.xls;"+
     "Extended Properties=Excel 8.0;";
    this.oleDbConnection1.ConnectionString=strConnection;
    this.oleDbDataAdapter1.SelectCommand.CommandText="SELECT * FROM MySheetName";
    this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
    this.oleDbDataAdapter1.Fill(this.dataSet1);   
    this.dataGrid1.DataSource=this.dataSet1; 
    if(!this.dataGrid1.IsExpanded(0))
     this.dataGrid1.Expand(0);
   }
   catch(Exception Err)
   {
    MessageBox.Show("读取EXCEL文件出现错误："+Err.Message,"信息提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
   }
  }

  private void Form1_Closed(object sender, System.EventArgs e)
  {//关闭程序
   //如果打开了连接，则关闭它
   if(this.oleDbConnection1.State==ConnectionState.Open)
   {
    this.oleDbConnection1.Close();
   }   
  }