python 字符串去除转义

python 字符串去除转义

字符串中有“\u0000”，写入EXL是会报错“openpyxl.utils.exceptions.IllegalCharacterErro”

from openpyxl import Workbook

exlfile = "xxxxx.xlsx"
wb = Workbook()
wb.create_sheet("sheet1", index=0)
ws = wb.active
value = "\u0000"
ws['A1'] = value
wb.save(exlfile)

因为会对\u0000进行转义，导致报错，取消‘\u0000’的转义就不会报错了

方法一：
字符串加上r取消转义，value = r"\u0000"

from openpyxl import Workbook

exlfile = "xxxxx.xlsx"
wb = Workbook()
wb.create_sheet("sheet1", index=0)
ws = wb.active
value = r"\u0000"
ws['A1'] = value
wb.save(exlfile)

方法二：（此方法不行）
对于变量用repr()取消转义，value = repr(value)

from openpyxl import Workbook

exlfile = "xxxxx.xlsx"
wb = Workbook()
wb.create_sheet("sheet1", index=0)
ws = wb.active
value = "\u0000"
value = repr(value)
ws['A1'] = value
wb.save(exlfile)