openpyxl.utils.exceptions.IllegalCharacterError

# 如果向excel写入了非法字符会报这种错误 需要提前把非法字符给替换掉再写入 ILLEGAL_CHARACRERS_RE表示非法字符的正则表达式 如下实例
from openpyxl.cell.cell import ILLEGAL_CHARACTERS_RE
import re
import openpyxl

......
value1 = "..."
value2 = "...存在非法字符..."
value2 = re.sub(ILLEGAL_CHARACTERS_RE, "", value2)
ws.append([value1, value2])