pip3 install openpyxl
from openpyxl.cell.cell import ILLEGAL_CHARACTERS_RE
s = '帮我们解决问题,谢谢\x00\x00\x00\x00' # \x00为非法字符
print(s.encode())
s = ILLEGAL_CHARACTERS_RE.sub(r'', s)
pip3 install openpyxl
from openpyxl.cell.cell import ILLEGAL_CHARACTERS_RE
s = '帮我们解决问题,谢谢\x00\x00\x00\x00' # \x00为非法字符
print(s.encode())
s = ILLEGAL_CHARACTERS_RE.sub(r'', s)