Ask Your Question
0

pssexcel not running

asked 2015-03-27 16:15:38 -0500

ClaireL gravatar image

updated 2015-03-27 16:19:42 -0500

I have followed all of the tutorial on this site for setting up and running load flows in PSSe 33. I have a .acc file and I'm trying to import this data to Excel 2010. `en....

ACCC file location

ACCFILE = r"""H:......\sample_N-1.acc""" import psspy, redirect, pssexcel #end imports

pssexcel accc file import

pssexcel.accc( accfile = ACCFILE, string=['s','e','b'], colabel='', stype='contingency', busmsm=0.5, sysmsm=5.0, rating='a', namesplit=True, xlsfile='Book1.xls', sheet='', overwritesheet=True, show=True, ratecon='b', baseflowvio=False, basevoltvio=False, flowlimit=100.0, flowchange=0.0, voltchange=0.0 )

The output is: File ".\pssexcel.py", line 1140, in accc File ".\pssexcel.py", line 253, in openworkbook_worksheets File ".\excelpy.py", line 1892, in workbook File ".\excelpy.py", line 194, in init TypeError: float() argument must be a string or a number`

Any suggestions? I have the win23api in the PSSE33\PSSBIN folder.

edit retag flag offensive close merge delete

1 answer

Sort by » oldest newest most voted
0

answered 2015-07-08 13:27:54 -0500

ClaireL gravatar image

updated 2015-07-08 13:29:26 -0500

I figured it out, you need to Import psspy and initialize PSSe before Import pssexcel. PSSEXCEL won't run until the PSS/e is open and running in the terminal.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

[hide preview]

Question Tools

1 follower

Stats

Asked: 2015-03-27 16:15:38 -0500

Seen: 1,567 times

Last updated: Jul 08 '15