“工作簿”对象没有属性“add_chart”

Question

我遇到了这个错误：AttributeError: 'Workbook' object has no attribute 'add_chart'运行此代码时（python 版本 3.7.4）：import reimport pandas as pdfrom pandas import ExcelWriterfrom pandas import ExcelFileimport numpy# ... other code here not involved to this part ...df = pd.DataFrame({"city": city_list, "tourist": tourist_list, "month": month_list})writer = pd.ExcelWriter('C:\\Users\\portovenere\\Downloads\\exc.xlsx')workbook = writer.bookchart = workbook.add_chart({'type': 'column'})chart.add_series({    'totals':     '=Sheet1!$A$3:$A$21',    'gap':        2,})add_chart我正在关注的这个pandas xlsx-writer 文档中解释了用法。我看到add_chart在XlsxWriter/workbook.py第 228 行定义def add_chart(self, options):        """        Create a chart object.        Args:            options: The chart type and subtype options.        Returns:            Reference to a Chart object.        """我错过了什么？

Answer 1

添加这一行

import xlsxwriter

正如本 Q/A中所建议的那样，并按照评论中的建议进行指定xlsxwriter，解决了这个问题。