python批量修改xlsx超出范围。

Question

import openpyxl
from random import randint

workbook=openpyxl.load_workbook("D:\Python\output_sample.xlsx")
> worksheet=workbook.worksheets[0]
for index,row in enumerate(worksheet.rows):
    if index==0:
        pass
    else:
        row[0].value=randint(0,1)

workbook.save(filename="D:\Python\output_sample.xlsx")

运行以后输出如下：
d:\python\lib\site-packages\openpyxl\reader\workbook.py:88: UserWarning: File contains an invalid specification for Sheet1. This will be removed
warn(msg)

运行后报以下错误：
IndexError Traceback (most recent call last)
in
3
4 workbook=openpyxl.load_workbook("D:\Python\output_sample.xlsx")
----> 5 worksheet=workbook.worksheets[0]
6 for index,row in enumerate(worksheet.rows):
7 if index==0:

IndexError: list index out of range
请问这是怎么回事？

Answer 1

文件路径"D:\Python\output_sample.xlsx"应该是

"D:\\Python\\output_sample.xlsx"

吧

可以在workbook.worksheets[0]前加上print(len(workbook.worksheets))，看看worksheets的长度