pip install openpyxl

import os
from openpyxl import load_workbook
def xlsx_read():
    addr = "openpyxl.xlsx"
    if not os.path.exists(addr):
        return '文件不存在'
    wb = load_workbook(addr)  # 打开加载文件
    # 读取表
    ws = wb['Sheet']
    row_max = ws.max_row  # 获取当前Sheet表格的最大行
    col_max=ws.max_column
    for i in range(1,row_max+1):
        for k in range(1,col_max+1):
            print(ws.cell(row=i, column=k).value,end='\t\t\t')
        print()
    wb.save(addr)
    print('读取完成')
xlsx_read()