c# OleDb读取excel

OleDb读取excel

using System.Data.OleDb;//connectOleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + excel路径 + ";" + "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';");//OpenobjConn.Open();//sheet nameDataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);//sql selectstring strSql = "select * from [" + sheetName + "]";OleDbDataAdapter myData = new OleDbDataAdapter(strSql, objConn);// set to datasetDataSet ds = new DataSet();myData.Fill(ds, sheetName);//closeobjConn.Close();//set to datatableDataTable dt = ds.Tables[sheetName];