# Copyright (c) 2010-2024 openpyxl
|
|
"""
|
OOXML has non-standard escaping for characters < \031
|
"""
|
|
import re
|
|
|
def escape(value):
|
r"""
|
Convert ASCII < 31 to OOXML: \n == _x + hex(ord(\n)) + _
|
"""
|
|
CHAR_REGEX = re.compile(r"[\001-\031]")
|
|
def _sub(match):
|
"""
|
Callback to escape chars
|
"""
|
return "_x{:0>4x}_".format(ord(match.group(0)))
|
|
return CHAR_REGEX.sub(_sub, value)
|
|
|
def unescape(value):
|
r"""
|
Convert escaped strings to ASCIII: _x000a_ == \n
|
"""
|
|
|
ESCAPED_REGEX = re.compile("_x([0-9A-Fa-f]{4})_")
|
|
def _sub(match):
|
"""
|
Callback to unescape chars
|
"""
|
return chr(int(match.group(1), 16))
|
|
if "_x" in value:
|
value = ESCAPED_REGEX.sub(_sub, value)
|
|
return value
|
