我正在尝试使用python的xlwt包将我的Excel电子表格的颜色更改为颜色代码数据。这是我目前的代码:
from xlrd import open_workbook
from tempfile import Temporary File
from xlwt
import sys
import csv
....
....#Some other code
style = xlwt.XFStyle() #this is the line throwing the error
pattern = xlwt.Pattern()
pattern.pattern = xlwt.Pattern.SOLID_PATTERN
pattern.pattern_fore_colour = xlwt.Style.colour_map['red']
pattern.pattern_fore_colour = xlwt.Style.colour_map['red']
newSheet.write(row, col, values[row - 1][col], pattern)
....
....#Some other code
其他代码部分是因为它是一个比显示的更长的脚本,但这些代码部分与此问题无关
运行时我得到以下堆栈跟踪:
Traceback (most recent call last):
File "excel-procesor.py", line 85, in
newSheet.write(row, col, values[row - 1][col], pattern)
File "/usr/local/