Skip to content
This repository has been archived by the owner on Jul 12, 2022. It is now read-only.

Excel Usage #5

Open
MikeDares opened this issue Oct 2, 2018 · 0 comments
Open

Excel Usage #5

MikeDares opened this issue Oct 2, 2018 · 0 comments

Comments

@MikeDares
Copy link

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant