时间戳

首页 > 解决方案 > xlwt.Style.EasyXFCallerError：“填充”部分未知

python - xlwt.Style.EasyXFCallerError：“填充”部分未知

问题描述

我有一个数据框，我正在其中进行更新，例如将背景颜色写入特定单元格并将其添加到特定单元格。它看起来很好dataframe。但是当我转换dataframe为excel时，发现以下错误。

df.to_excel("test_sheet.xls")导致错误。

Traceback (most recent call last):
  File "scoring_model.py", line 441, in <module>
    pf = ScoringModel()
  File "scoring_model.py", line 12, in __init__
    self.start_scoring()
  File "scoring_model.py", line 185, in start_scoring
    df.to_excel("test_sheet.xls")
  File "D:\Projects\Scoring Model\venv\lib\site-packages\pandas\io\formats\style.py", line 187, in to_excel
    engine=engine)
  File "D:\Projects\Scoring Model\venv\lib\site-packages\pandas\io\formats\excel.py", line 662, in write
    freeze_panes=freeze_panes)
  File "D:\Projects\Scoring Model\venv\lib\site-packages\pandas\io\excel.py", line 1708, in write_cells
    style = self._convert_to_style(cell.style, fmt)
  File "D:\Projects\Scoring Model\venv\lib\site-packages\pandas\io\excel.py", line 1771, in _convert_to_style
    style = xlwt.easyxf(xlwt_stylestr, field_sep=',', line_sep=';')
  File "D:\Projects\Scoring Model\venv\lib\site-packages\xlwt\Style.py", line 733, in easyxf
    field_sep=field_sep, line_sep=line_sep, intro_sep=intro_sep, esc_char=esc_char, debug=debug)
  File "D:\Projects\Scoring Model\venv\lib\site-packages\xlwt\Style.py", line 638, in _parse_strg_to_obj
    raise EasyXFCallerError('section %r is unknown' % section)
xlwt.Style.EasyXFCallerError: section 'fill' is unknown

使用python3.5和xlwt 1.3最新。有没有人发现同样的错误？

谢谢

标签： pythonexcelpython-3.xpandasxlwt

解决方案

听起来很蹩脚，我遇到了同样的困难，当我改变时就停止了

df.to_excel("test_sheet.xls")

到

df.to_excel("test_sheet.xls x ")

FWIW我也在使用'xlsxwriter'

推荐阅读