// 定义文件路径
string path = @"D:\Users\19599\Downloads\文件名.xlsx";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + "Extended Properties='Excel 8.0;HDR=False;IMEX=1'";
// 打开连接
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
// 查询表格的sheet页
string strExcel = "select * from [Sheet名称$]";
OleDbDataAdapter myCommand = new OleDbDataAdapter(strExcel, strConn);
DataSet ds = new DataSet();
// 获取sheet页数据
myCommand.Fill(ds, "Sheet名称");
DataTable table = ds.Tables[0];