JRCSTU/wltp

Excel Usage

MikeDares opened this issue · 0 comments

Hi Kostis,
My problem is, I can get the tool running using Python through cmd.exe, but I cannot get it running through Excel.

The “--excelrun” command isn’t implemented in the versions I installed and when starting it directly from the .xlsm in the wltp folder I always get errors, that I could not locate exactly so far. It works until you run the commands through cmd.exe at this point:

ExitCode = Wsh.Run("cmd.exe /C " & DriveCommand & _
RunCommand & _
"""" & WORKBOOK_FULLNAME & """ ""from_xl"" 2> """ & LOG_FILE & """ ", _
WindowStyle, WaitOnReturn)

But I don’t know, what the exact error is, the log says:

File "", line 1
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

I am using:
Windows 7 Enterprise Service Pack 1
Wltp 0.1.0-alpha3 (I tried older versions for --excelrun, too)
Python 3.6.0
Anaconda 4.3.0 (64-bit)
pandas 0.23.4
xlwings 0.11.8

Maybe I am doing a common mistake and you can tell me right away, what my problem is. Thank you in advance for your help.

Also when starting it from cmd with "wltp --excel" I get the message, that:

wltp: Model validation failed due to: None is not of type 'number'

Failed validating 'typeÄ in schema ['properties']['vehicle]['properties]['n_idle']:
<'exclsuiveMinimum': True, 'minimum': 0, 'type': 'number'>
On instance['vehicle']['n_idle']:
None

Best regards,
Mike