First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

fadi
1 ●4 ●6 ●5

Hey all, i am trying to export psse data to excel using python. When I try to execute 'import excelpy', it gives following error

Traceback (most recent call last): File "C:\Users\Hassan\Desktop\Automation\test.py", line 7, in <module> import excelpy File ".\excelpy.py", line 168, in <module> File "C:\Program Files\Python 2.7\lib\site-packages\win32com_init_.py", line 5, in <module> import win32api, sys, os ImportError: DLL load failed: The specified module could not be found. Couldn't open Python file:C:\Users\Hassan\Desktop\Automation\test.py

Please help.

Comments

I have the same problem, can someone solve it?

YI-WEI (Aug 27 '17)

add a comment

1 answer

Sort by » oldest newest most voted

answered Jul 19 '17

knucklehead
21 ●1 ●2 ●4

updated Jul 19 '17

Which PSSE version are you using? Are you setting the environment variables?

#SET EVIRONMENT VARIABLES --------------------------------------------------
    if psseversion==1:
        try: import psse34
        except: psseversion=0
    if psseversion==0:
        _PSSBINPATH = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN"
        os.environ['PATH'] = _PSSBINPATH + ';' + os.environ['PATH']
        sys.path.insert(0,_PSSBINPATH)