Python [ site-Package ] [ xlwt ] [ ValueError: cannot use LOCALE flag with a str pattern ]

最新推荐文章于 2022-11-28 23:04:57 发布

原创最新推荐文章于 2022-11-28 23:04:57 发布 · 6k 阅读

CC 4.0 BY-SA版权

文章标签：

8 篇文章

订阅专栏

在Windows 7环境下，使用Python 3.7进行Excel读写操作时遇到错误。问题源于xlwt库的一个bug，提示不能在字符串模式下使用LOCALE标志。解决方案是卸载并重新安装xlwt库，通过`pip uninstall xlwt`和`pip install xlwt`更新版本。

问题情境
win7 + python3.7 + 读写execl时报错：
Log
Traceback (most recent call last):
File “parse-excel.py”, line 4, in
import xlwt,xlrd,sys
File “C:\Python37\lib\site-packages\xlwt_init_.py”, line 4, in
from .Worksheet import Worksheet
File “C:\Python37\lib\site-packages\xlwt\Worksheet.py”, line 38, in
from .Row import Row
File “C:\Python37\lib\site-packages\xlwt\Row.py”, line 7, in
from . import ExcelFormula
File “C:\Python37\lib\site-packages\xlwt\ExcelFormula.py”, line 3, in
from . import ExcelFormulaParser, ExcelFormulaLexer
File “C:\Python37\lib\site-packages\xlwt\ExcelFormulaLexer.py”, line 53, in
VERBOSE+LOCALE+IGNORECASE)
File “C:\Python37\lib\re.py”, line 234, in compile
return _compile(pattern, flags)
File “C:\Python37\lib\re.py”, line 286, in _compile
p = sre_compile.compile(pattern, flags)
File “C:\Python37\lib\sre_compile.py”, line 764, in compile
p = sre_parse.parse(p, flags)
File “C:\Python37\lib\sre_parse.py”, line 940, in parse
p.pattern.flags = fix_flags(str, p.pattern.flags)
File “C:\Python37\lib\sre_parse.py”, line 907, in fix_flags
raise ValueError(“cannot use LOCALE flag with a str pattern”)
ValueError: cannot use LOCALE flag with a str pattern
问题原因
xlwt版本较低，存在bug，需更新版本
解决办法
卸载并重装xlwt

pip uninstall xlwt
pip install xlwt
Reference
https://github.com/kennethreitz/tablib/issues/254