nrows python_sheet.nrows有一个错误的值 – python excel文件

要确保您的文件没有损坏,请尝试使用其他文件;我怀疑xlrd是否有缺陷.

此外,我已经清理你的代码看起来更好一点.例如,if行> 0检查是不必要的,因为你可以在第一个位置迭代范围(1,sheet.nrows).

def get_data_form_excel(address):

# this returns a generator not a list; you can iterate over it as normal,

# but if you need a list, convert the return value to one using list()

for sheet in xlrd.open_workbook(address).sheets():

for row in range(1, sheet.nrows):

yield [str(sheet.cell(row, col).value) for col in range(sheet.ncols)]

要么

def get_data_form_excel(address):

# you can make this function also use a (lazily evaluated) generator instead

# of a list by changing the brackets to normal parentheses.

return [

[str(sheet.cell(row, col).value) for col in range(sheet.ncols)]

for sheet in xlrd.open_workbook(address).sheets()

for row in range(1, sheet.nrows)

]