使用pip install openpyxl会自动安装openpyxl-3.0.5,
运行代码后:
下面展示一些 内联代码片
。
// An highlighted block
from openpyxl import load_workbook
wb=load_workbook('PlData(20201011080905).xlsx')
然后出现下面错误:
D:\chengxu\anaconda\python.exe D:/python_project/movementAnalysis/pLabel.py
Traceback (most recent call last):
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\descriptors\base.py”, line 55, in _convert
value = expected_type(value)
TypeError: int() argument must be a string, a bytes-like object or a number, not ‘NoneType’
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “D:/python_project/eyemovementAnalysis/pupilLabel.py”, line 5, in
wb=load_workbook(‘PupilData(20201011080905).xlsx’)
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\reader\excel.py”, line 315, in load_workbook
reader.read()
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\reader\excel.py”, line 280, in read
self.read_worksheets()
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\reader\excel.py”, line 228, in read_worksheets
ws_parser.bind_all()
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\worksheet_reader.py”, line 434, in bind_all
self.bind_cells()
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\worksheet_reader.py”, line 337, in bind_cells
for idx, row in self.parser.parse():
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\worksheet_reader.py”, line 149, in parse
obj = prop[1].from_tree(element)
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\descriptors\serialisable.py”, line 87, in from_tree
obj = desc.expected_type.from_tree(el)
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\descriptors\serialisable.py”, line 103, in from_tree
return cls(**attrib)
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\worksheet\merge.py”, line 26, in init
super(MergeCell, self).init(ref)
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\worksheet\cell_range.py”, line 55, in init
self.min_col = min_col
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\descriptors\base.py”, line 105, in set
value = _convert(self.expected_type, value)
File “D:\chengxu\anaconda\lib\site-packages\openpyxl\descriptors\base.py”, line 57, in _convert
raise TypeError('expected ’ + str(expected_type))
TypeError: expected <class ‘int’>
看了一些博客说是openpyxl的版本问题,要低于2.5.0,于是手动安装openpyxl:
https://webscripts.softpedia.com/dyn-search.php?search_term=openpyxl
在上面连接下载安装包,解压下载的安装包,进入包含setup.py文件的目录,
在cmd中执行命令:python setup.py install
文件会自动安装到python的目录中。