Non-ASCII character '\xb7' of xlsm file

Asked Sep 21 '16 at 20:48

Active Sep 21 '16 at 21:53

Viewed 510 times

I am trying to run vba_extract.py in Visual Studio by IronPython. The compilation returns an error:

An unhandled exception of type 'Microsoft.Scripting.SyntaxErrorException' occurred in IronPython.dll

Additional information: Non-ASCII character '\xb7' in file ../../python/vba_extract.py ../../../tests/test.xlsm on line 1, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details

I searched this issue, and added encoding in Line 2 of vba_extract.py:

#!python
# -*- coding: utf-8 -*-

But it still does not work.

Additionally, I tried the following two lines, which returned the same error:

engine.ExecuteFile(@"../../python/irrelevant.py ../../../tests/test.xlsm");
engine.ExecuteFile(@"../../tests/test.xlsm");

So I guess the problem is from the encoding of test.xlsm.

Could anyone help?

edited Sep 21 '16 at 21:53

asked Sep 21 '16 at 20:48

SoftTimur

5,630
38
140
292

try `# -*- coding: latin-1 -*-` – Jean-François Fabre Sep 21 '16 at 20:52
still does not work... same error... – SoftTimur Sep 21 '16 at 20:53
Is it complaining about test.xlsm? Plenty of non-ascii characters there, I'm sure. – Mick Sep 21 '16 at 20:55
It is possible, it is just an Excel file (with macros), so is there anything I could do? – SoftTimur Sep 21 '16 at 20:56
that could help: http://stackoverflow.com/questions/17675780/how-to-save-xlsm-file-with-macro-using-openpyxl – Jean-François Fabre Sep 21 '16 at 21:04
Are you sure that's your exact first line of your file? The error is complaining about line 1. The byte `0xb7` doesn't appear to be there. Maybe try deleting both lines entirely and retyping them in manually. – Dunes Sep 21 '16 at 21:23
Please see my updates... – SoftTimur Sep 21 '16 at 21:53

Non-ASCII character '\xb7' of xlsm file

0 Answers0