asp.net(c#)访问Excel小例

private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   string strConn;
   strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
      +"Data Source=C://test.xls;"
      +"Extended Properties=Excel 8.0;";
   OleDbConnection cn = new OleDbConnection(strConn);
   OleDbCommand myCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", cn);
   System.Data.OleDb.OleDbDataAdapter da = new OleDbDataAdapter(myCommand);
   System.Data.DataSet ds = new System.Data.DataSet();
   
   da.Fill(ds,"[Sheet1$]");
   DataGrid1.DataSource = ds.Tables[0].DefaultView;
   DataGrid1.DataBind();
  }