from openpyxl import load_workbook
workbook_object = load_workbook(filename='C:/Users/test/Desktop/test.xlsx')
sheetNames= workbook_object.sheetnames
for tmp in sheetNames:
ws = workbook_object[tmp]
[print(ws.cell(i,j).value) for i in range(1,ws.max_row+1) for j in range(1,ws.max_column+1)]
workbook_object.close()


