import openpyxl
workbook = openpyxl.load_workbook("C:\\Users\\Riven\\Desktop\\naodao.xlsx")
print(workbook.sheetnames)
sheet1 = workbook.sheetnames[0]
sheet = workbook[sheet1]
print(sheet.dimensions)#获取表的尺寸
import openpyxl
workbook = openpyxl.load_workbook("C:\\Users\\Riven\\Desktop\\naodao.xlsx")
print(workbook.sheetnames)
sheet1 = workbook.sheetnames[0]
sheet = workbook[sheet1]
print(sheet.dimensions)#获取表的尺寸