连接Excel库代码

连接Excel库代码
System.Data.OleDb.OleDbConnection 
con1=new System.Data.OleDb.OleDbConnection(); 
string constr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C://test2.xls;Extended Properties=Excel 8.0;";
con1.ConnectionString=constr; 
con1.Open();
System.Data.OleDb.OleDbCommand com1=new System.Data.OleDb.OleDbCommand(); 
com1.CommandText="SELECT ww1 FROM [Sheet1$] "; 
com1.Connection=con1; 
System.Data.OleDb.OleDbDataAdapter ap=new System.Data.OleDb.OleDbDataAdapter(com1);  
ap.Fill(ds);   
this.DataGrid1.DataSource=ds;   
this.DataGrid1.DataBind();