Revision history [back]

what I want: I want to export my .out file to Excel file by using [Run Automation File] button or python command.

what I do: I click Button [Start Recording], save a python file "out2excel.py". then I open my output file "t007.outx" in PSSE's GUI, and I right-click [t007] in left Plot Tree->Plot Data->Channel Files, then the corresponding excel window open successfully. I find api "pssplot.channelfileexcelexport()" is the key to export.out/.outx file to Excel file.

what error: When I restart PSSE, click [Run Automation File], select "out2excel.py" to do the same operation, some errors show in Output Bar:

  Call failed (result is null)
    Traceback (most recent call last):
      File ".\dyntools.py", line 2427, in _xlsout
      File ".\dyntools.py", line 1023, in __init__
      File ".\dyntools.py", line 351, in _outextract_data
      File ".\dyntools.py", line 321, in _outextract_id
    Exception: ERROR ... File c:\users\yang\documents\pti\psse34\test-ieee\1-9bus-test\t007.outx version is 1.47195436916e+19
        dyntools handles version 2.0 files only.

I copy python script: pssplot.channelfileexcelexport(r"""C:\Users\Yang\Documents\PTI\PSSE34\test-IEEE\1-9Bus-test\t007.outx""")to Command Line Input, the same error still exists.

My PSSE verion is v34, my python version is 2.7, and other automation operationlike 'open case data, do power flow solution' can be performed normally.

So how can I perform this api to export.out file to Excel file successfully? Thank you for helping.

what I want: I want to export my .out file to Excel file by using [Run Automation File] button or python command.

what I do: I click Button [Start Recording], save a python file "out2excel.py". then I open my output file "t007.outx" in PSSE's GUI, and I right-click [t007] in left Plot Tree->Plot Data->Channel Files, then the corresponding excel window open successfully. I find api "pssplot.channelfileexcelexport()" is the key to export.out/.outx file to Excel file.

what error: When I restart PSSE, click [Run Automation File], select "out2excel.py" to do the same 'auto export' operation, some errors show in Output Bar:

  Call failed (result is null)
    Traceback (most recent call last):
      File ".\dyntools.py", line 2427, in _xlsout
      File ".\dyntools.py", line 1023, in __init__
      File ".\dyntools.py", line 351, in _outextract_data
      File ".\dyntools.py", line 321, in _outextract_id
    Exception: ERROR ... File c:\users\yang\documents\pti\psse34\test-ieee\1-9bus-test\t007.outx version is 1.47195436916e+19
        dyntools handles version 2.0 files only.

I copy python script: pssplot.channelfileexcelexport(r"""C:\Users\Yang\Documents\PTI\PSSE34\test-IEEE\1-9Bus-test\t007.outx""")to Command Line Input, the same error still exists.

My PSSE verion is v34, my python version is 2.7, and other automation operationlike 'open case data, do power flow solution' can be performed normally.

So how can I perform this api to export.out file to Excel file successfully? Thank you for helping.