I get an error: UnicodeEncodeError: 'charmap' codec can't encode character '\u2264' in position 0: character maps to when the pycodestyle check_files hits this line:
worksheet1.write_formula('E' + str(i), '=IF(F' + str(i) + '>G' + str(i) + ',"↑",IF(F' + str(i) + '=G' + str(i) + ',"↔","↓"))', arrows_format)
How can I keep using the Unicode and use the pycodestyle checker? (I'm assuming it's the arrow characters that cause the error)
This seems important: To capture the pycodestyle output (print) I use :
sys.stdout = open(ReportPath, 'w')
and save the 'print' output to a file. I think this is important because the 'print()' that pycodestyle tries does not actually happen.