查看区域数据

#打开文件

wb = load_workbook('newexcel.xlsx')

#使用哪个页签

ws = wb.active

#读取数值

for row in range(1,5):

    for col in range(1,5):

        char = get_column_letter(col)

        print(ws[char + str(row)],ws[char + str(row)].value)

wb.save('newexcel.xlsx')