openpyxl写入时出现openpyxl.utils.exceptions.IllegalCharacterError错误
解决方法将openpyxl定义的非法字符用空字符代替,具体方法如下from openpyxl.cell.cell import ILLEGAL_CHARACTERS_REimport openpyxlimport re# 写入之前,先将非法字符用空格代替content = ILLEGAL_CHARACTERS_RE.sub(r'', content)ws.cell(ridx, ci...
原创
2020-03-11 15:25:50 ·
9426 阅读 ·
2 评论