Pycharm使用xlwt时，报错的解决方法

Traceback (most recent call last):
  File "E:/Python-1704/python/day15/10-excel自动化办公/10-4-写入xls文件.py", line 30, in <module>
    "表2": [[11, 22, 33], [44, 55, 66], [77, 88, 99]]})
  File "E:/Python-1704/python/day15/10-excel自动化办公/10-4-写入xls文件.py", line 25, in makeExcelFile
    save_data(path, dic)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\pyexcel_xls\__init__.py", line 39, in save_data
    write_data(afile, data, file_type=file_type, **keywords)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\pyexcel_io\io.py", line 140, in store_data
    with get_writer(**keywords) as writer:
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\pyexcel_io\io.py", line 213, in get_writer
    writer = WRITERS.get_a_plugin(file_type, library)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\pyexcel_io\plugins.py", line 77, in get_a_plugin
    plugin = self.load_me_now(__file_type, library=library)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\lml\plugin.py", line 275, in load_me_now
    cls = self.dynamic_load_library(plugin_info)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\lml\plugin.py", line 303, in dynamic_load_library
    cls = do_import_class(a_plugin_info.absolute_import_path)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\lml\utils.py", line 59, in do_import_class
    plugin_module = __import__(plugin_module_name)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\pyexcel_xls\xlsw.py", line 12, in <module>
    from xlwt import Workbook, XFStyle
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\xlwt\__init__.py", line 5, in <module>
    from .Row import Row
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\xlwt\Row.py", line 9, in <module>
    from . import ExcelFormula
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\xlwt\ExcelFormula.py", line 8, in <module>
    from . import ExcelFormulaParser, ExcelFormulaLexer
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\site-packages\xlwt\ExcelFormulaLexer.py", line 55, in <module>
    VERBOSE+LOCALE+IGNORECASE)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\re.py", line 233, in compile
    return _compile(pattern, flags)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\re.py", line 301, in _compile
    p = sre_compile.compile(pattern, flags)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\sre_compile.py", line 562, in compile
    p = sre_parse.parse(p, flags)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\sre_parse.py", line 866, in parse
    p.pattern.flags = fix_flags(str, p.pattern.flags)
  File "C:\Users\yangyangyang\AppData\Local\Programs\Python\Python36\lib\sre_parse.py", line 833, in fix_flags
    raise ValueError("cannot use LOCALE flag with a str pattern")
ValueError: cannot use LOCALE flag with a str pattern

解决办法：

在我的电脑里面搜索sre_parse.py

进入此文件，找到以下的一句代码

将它改成如下：

这样写xls文件时就不会报错了