已安装Python3.4和模块jdcal
和openpyxl
:
在openpyxl
库上尝试从Python读取和写入XLSX文件。我安装了jdcall
模块和openpyxl
模块。代码允许我创建工作簿和工作表:
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
但是,如果我试图这样写第一个单元格:
ws[ 1, 1] = 'testing 1-2-3'
Python说:
C:\Wolf\Python Studies>database.py Traceback (most recent call last): File "C:\Wolf\Python Studies\database.py", line 13, in <module> ws[ 1, 1] = 'testing 1-2-3' File "C:\Python34\lib\site-packages\openpyxl-2.2.0b1-py3.4.egg\openpyxl\worksheet\worksheet.py", line 403, in __setitem__ self[key].value = value File "C:\Python34\lib\site-packages\openpyxl-2.2.0b1-py3.4.egg\openpyxl\worksheet\worksheet.py", line 400, in __getitem__ <BR> return self._get_cell(key) File "C:\Python34\lib\site-packages\openpyxl-2.2.0b1-py3.4.egg\openpyxl\worksheet\worksheet.py", line 368, in _get_cell coordinate = coordinate.upper() AttributeError: 'tuple' object has no attribute 'upper' C:\Wolf\Python Studies>
知道我做错了什么吗?
单元格坐标应以字符串形式提供:
或者,如果要使用行和列索引,请使用
ws.cell().value
:相关问题 更多 >
编程相关推荐