PYTHON+PANDAS+OPENPYXL Download xls illegalcharactererror

Just urllib2.unquote_plus decoding is not enough, you need to remove the special characters

Illegal_characters_re = Re.compile (R ' [\000-\010]|[ \013-\014]| [\016-\037]|\XEF|\XBF ')

Value = Illegal_characters_re.sub ("', Origin_value)

Due to the existence of \XEF|\XBF, resulting in string garbled, check this is as Utf-8 BOM existence, need to filter out.

Bom:https://en.wikipedia.org/wiki/byte_order_mark#utf-8

ASCII characters:http://donsnotes.com/tech/charsets/ascii.html

Then, it worked for me.

PYTHON+PANDAS+OPENPYXL Download xls illegalcharactererror