Exporting PV curve data from PSS/E to excel

answered 2013-11-21 18:02:01 -0500

jconto
2701 ●10 ●30 ●41

update your PSSe 33 installation as follows (standard installation of PSSe v.33.4.0):

Problem: error in loading “win32” module that allow Excel file to be open in python

Solution: move (not copy) files _win32sysloader.pyd and win32api.pyd

from folder C:\Program Files (x86)\PTI\PSSE33\PSSBIN

to folder C:\Program Files (x86)\PTI\PSSE33\PSSPY27

answered 2013-11-27 11:36:53 -0500

yfwing
426 ●2 ●3 ●8

@Thomas Ebdrup, try @terrytian 's method, but you don't need import psspy if you are just going to export PV to excel. Import psspy and initialize it may create some trouble to you if your PSS/E environment is not probably set.

The problem with import pssexcel within PSS/E is known problem to PTI. It is caused by the different version of VC++ compiler used for PSS/E python modules and the Python 2.7 win32api module. The C++ runtime library used by PSS/E is not compatible with Python 2.7 module. But you can work around using @terrytian 's method.

answered 2013-11-26 12:58:13 -0500

terrytian
49 ●4 ●7 ●10

updated 2013-11-26 12:59:25 -0500

I recommend you to run python on top of PSS/E. In other words, run the python script without PSS/E.

You can search this topic in this forum.

The basic idea is to add the following lines before your original python script to let it know where your PSS/E library installed.

import sys
import os

PSSE_LOCATION = r'C:\Program Files (x86)\PTI\PSSE33\PSSBIN' # your location may be different
sys.path.append(PSSE_LOCATION)
os.environ['PATH'] = os.environ['PATH'] + ';' +  PSSE_LOCATION

import psspy
import pssarrays
from psspy import _i, _f, _c
import redirect
redirect.psse2py()

import pssexcel # now this module can be loaded without error
psspy.psseinit() # this start the pss/e in python