Python - 无法使用 XLRD 模块读取 xlsx 工作表

Question

我正在尝试读取xlsx工作表并将其附加到列表中。但是，下面的代码会引发错误。我无法解密错误是什么。 有人可以帮忙吗？

错误：TypeError: list indices must be integers or slices, not str

我的代码：

import xlrd
df = []
with xlrd.open_workbook(r'C:UsersTadDocumentstest.xlsx') as wb:
with wb.get_sheet('Selected products') as sheet:
for row in sheet.rows():
df.append([item.v for item in row])

另外，如果我使用"with wb.sheet_by_name('Selected products') as sheet:"，错误是："AttributeError: __enter__">

Answer 1

不要将 xlrd 用于新的 excel 文件。 而是使用 openpyxl。

https://openpyxl.readthedocs.io/en/stable/

from openpyxl import Workbook
wb = Workbook()
# grab the active worksheet
ws = wb.active
# Data can be assigned directly to cells
ws['A1'] = 42
# Rows can also be appended
ws.append([1, 2, 3])
# Python types will automatically be converted
import datetime
ws['A2'] = datetime.datetime.now()
# Save the file
wb.save("sample.xlsx")