python使用openpyxl方法循环输出excel表格内容

​​​​​​​from openpyxl import load_workbook
#openpyxl只能读取xlsx结尾的excel
# 加载现存的Excel文件
workbook = load_workbook(filename='test.xlsx')
# 选择工作表
sheet = workbook.active

# 读取单元格内容
cell = sheet['A1']
print(cell.value)
print(sheet.max_row)
m_rows=sheet.max_row
# 遍历行和列
for row in sheet.iter_rows(min_row=1, max_row=m_rows, min_col=1, max_col=3):
    for cell in row:
        print(cell.value, end="--")
    print()

# 关闭文件
workbook.close()

openpyxl只能读取xlsx结尾的excel，如果文件需要转格式，参阅文章Python转换excel表格文件格式.xls与.xlsx的互转-CSDN博客