使用openpyxl中的styles修改一个单元格的背景颜色,第一次运行程序可以修改背景颜色成功,但是再次运行这个python程序的时候,总是提示load_workbook失败,提示信息如下:
Traceback (most recent call last):
File "e:\pythoncode\switch.py", line 218, in
wbbb = load_workbook(file_path)
File "d:\Python27\lib\site-packages\openpyxl-2.5.0a2-py2.7.egg\openpyxl\reader\excel.py", line 222, in load_workbook
apply_stylesheet(archive, wb) # bind styles to workbook
File "d:\Python27\lib\site-packages\openpyxl-2.5.0a2-py2.7.egg\openpyxl\styles\stylesheet.py", line 182, in apply_stylesheet
stylesheet = Stylesheet.from_tree(node)
File "d:\Python27\lib\site-packages\openpyxl-2.5.0a2-py2.7.egg\openpyxl\styles\stylesheet.py", line 99, in from_tree
return super(Stylesheet, cls).from_tree(node)
File "d:\Python27\lib\site-packages\openpyxl-2.5.0a2-py2.7.egg\openpyxl\descriptors\s