python如何读取数据时出现错误_在python中从excel读取数据时发生只读错误

我是python新手。在

我编写了一个用python从excel读取数据的示例代码。在from openpyxl import load_workbook

import logging

logging.basicConfig(level=logging.DEBUG)

wb = load_workbook(filename = 'names.xlsx', use_iterators = True)

for sheet in wb.get_sheet_names():

worksheet = wb.get_sheet_by_name(name=sheet)

print sheet

if worksheet:

index = 2

append_brace = False

while True:

gender_index = 'B' + str(index)

operator_index = 'C' + str(index)

name_index = 'D' + str(index)

lastname_index = 'E' + str(index)

middlename_index = 'F' + str(index)

print gender_index,"\n"

print worksheet[gender_index]

index = index+1;

运行此文件时，gender_索引（单元格）打印正确，但无法打印单元格值。在

以下是我看到的错误。在

^{pr2}$