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()
