AttributeError: module 'linecache' has no attribute 'lazycache'

Question

python版本

3.6.4 |Anaconda, Inc.| (default, Jan 16 2018, 10:22:32) [MSC v.1900 64 bit (AMD64)]

code

# -*- coding:utf-8 *-
import xlwings as xw
app=xw.App(visible=True,add_book=False)
# wb就是新建的工作簿(workbook)，下面则对wb的sheet1的A1单元格赋值
wb=app.books.add()
wb.sheets['sheet1'].range('A1').value='Hello'
wb.sheets[0].range(2,1).value='World!'
wb.save(r'd:\test.xlsx')
wb.close()
app.quit()

log

Traceback (most recent call last):
  File "D:\dev_workspace\python\python-study\06处理json功能文件导出为excel\excel_create.py", line 2, in <module>
    import xlwings as xw
  File "D:\ProgramData\Anaconda3\lib\site-packages\xlwings\__init__.py", line 23, in <module>
    from . import _xlwindows as xlplatform
  File "D:\ProgramData\Anaconda3\lib\site-packages\xlwings\_xlwindows.py", line 29, in <module>
    from .utils import rgb_to_int, int_to_rgb, get_duplicates, np_datetime_to_datetime, col_name
  File "D:\ProgramData\Anaconda3\lib\site-packages\xlwings\utils.py", line 18, in <module>
    import matplotlib as mpl
  File "D:\ProgramData\Anaconda3\lib\site-packages\matplotlib\__init__.py", line 128, in <module>
    from matplotlib.rcsetup import defaultParams, validate_backend, cycler
  File "D:\ProgramData\Anaconda3\lib\site-packages\matplotlib\rcsetup.py", line 29, in <module>
    from matplotlib.fontconfig_pattern import parse_fontconfig_pattern
  File "D:\ProgramData\Anaconda3\lib\site-packages\matplotlib\fontconfig_pattern.py", line 26, in <module>
    from pyparsing import (Literal, ZeroOrMore, Optional, Regex, StringEnd,
  File "D:\ProgramData\Anaconda3\lib\site-packages\pyparsing.py", line 4734, in <module>
    _escapedPunc = Word( _bslash, r"\[]-*.$+^?()~ ", exact=2 ).setParseAction(lambda s,l,t:t[0][1])
  File "D:\ProgramData\Anaconda3\lib\site-packages\pyparsing.py", line 1261, in setParseAction
    self.parseAction = list(map(_trim_arity, list(fns)))
  File "D:\ProgramData\Anaconda3\lib\site-packages\pyparsing.py", line 1043, in _trim_arity
    this_line = extract_stack(limit=2)[-1]
  File "D:\ProgramData\Anaconda3\lib\site-packages\pyparsing.py", line 1027, in extract_stack
    frame_summary = traceback.extract_stack(limit=-offset+limit-1)[offset]
  File "D:\ProgramData\Anaconda3\lib\traceback.py", line 207, in extract_stack
    stack = StackSummary.extract(walk_stack(f), limit=limit)
  File "D:\ProgramData\Anaconda3\lib\traceback.py", line 345, in extract
    linecache.lazycache(filename, f.f_globals)
AttributeError: module 'linecache' has no attribute 'lazycache'

上面的错误原因是什么,改如何解决

Answer 1

你的代码在正常环境里面是可以跑的，首先是要知道这代码是在哪个系统运行，此模块只支持mac和win及以上。如果是以上说的两种环境，还会出现问题，那么就请检查你的Excel是否安装正常，是否因安装wps导致冲突。大概就这样