python - 无法在 Python 中使用 XlsxWriter 定义输出文件

Question

我现在有了我能想象到的最简单的测试脚本，但它无法按照 XlsxWriter 的说明运行:

import pandas as pd
import numpy as np
import xlsxwriter

writer = pd.ExcelWriter("Test.xlsx", engine = "xlsxwriter")

完整错误: 回溯(最近一次调用最后一次):

  File "<ipython-input-310-9c7e424c6d39>", line 1, in <module>
    writer = pd.ExcelWriter("Test.xlsx", engine = "xlsxwriter")

  File "/Users/ernie/anaconda3/lib/python3.6/site-    packages/pandas/io/excel.py", line 1725, in __init__
    self.book = xlsxwriter.Workbook(path, **engine_kwargs)

  File "/Users/ernie/anaconda3/lib/python3.6/site-packages/xlsxwriter/workbook.py", line 68, in __init__
    super(Workbook, self).__init__()

TypeError: super(type, obj): obj must be an instance or subtype of type

Answer 1

这个错误显然与 Spyder 和 Python 运行的 session 有关。我完全退出 session ，重新启动它，错误消失了。有些东西不知何故被损坏了，但很奇怪。