PSSE 34 with excel

asked May 2 '17

tngo2104
1 ●1 ●1 ●1

Dear PSSY comunity,

I am sorry to throw this post on excel for using python in PSSE again.

I tried to search in this forum and goole but could not fix the problem.

Any ideas would be helpful. I installed PSSE 34 from Siemen website and used Python 2.7 as by following link: (http://www.whit.com.au/blog/python-li...)

I can run the PSSE now by Python by the commands:

import os
import sys
sys_path_PSSE=r'C:\Program Files (x86)\PTI\PSSEXplore34\PSSPY27'  #or where else you find the psspy.pyc
sys.path.append(sys_path_PSSE)
os_path_PSSE=r'C:\Program Files (x86)\PTI\PSSEXplore34\PSSBIN'  # or where else you find the psse.exe
os.environ['PATH'] += ';' + os_path_PSSE
import redirect
redirect.psse2py()
import psspy
psspy.psseinit(100)     # initialize psse with 100 bus system**

However, when I used import pssexcel, the error is below eventhough pssexcel was in the PSSPY27 folder.

Traceback (most recent call last):
File "C:\Users\Ngo Tuan\Desktop\tuan.py", line 14, in <module>
    import pssexcel
File ".\pssexcel.py", line 40, in <module>
ImportError: No module named excelpy

I tried to find excelpy but could not find the file. If anyone knows how to fix this, I would appreciate that.