String conn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source =***.xls; Extended Properties =Excel 8.0";
//在这里请注意这个字符串的形式,不要写错。
OleDbConnection connection =new OleDbConnection (conn);
DataTable dt=connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null);
//获得当前Excel的表名
List<String> sheetNames=new List<String>();
foreach(DataRow item in dt.Rows)
{
sheetNames.Add(item["TABLE_NAME"].ToString());
}
//填充数据
OleDbDataAdapter myCommand =new OleDbDataAdapter ("sELECT * fROM [tableName]",conn);
DataSet ds=new DataSet();
myCommand.Fill(ds);