import openpyxl
wc=openpyxl.load_workbook(r'C:\Users\Administrator\Desktop\*.xlsx')
sheet=wc.active
print(sheet)
rows=sheet.max_row
cols=sheet.max_column
print(rows)
for row in range(1,rows):
for col in range(1,cols):
print(sheet.cell(row,col).value)
ws = wc.get_sheet(0)
print(ws)