Ask Your Question

exporting dynamic simulation results to excel using python

asked 2013-11-18 04:18:45 -0500

PieterJ gravatar image

Hello all!

Does anybody know how to export the contents of the CHANNELs after a dynamic simulation to excel, using python commands?

thanks; and best regards!


edit retag flag offensive close merge delete

2 answers

Sort by ยป oldest newest most voted

answered 2013-11-18 11:29:13 -0500

yfwing gravatar image

You can try use 'dyntools' module. the function CHNF will read the dynamic simulation result files. then you can use 'xlsout' function to export to excel.

import os import sys sys.path.append('C:/Program Files (x86)/PTI/PSSEUniversity33/pssbin') sys.path.append('C:/Program Files (x86)/PTI/PSSEUniversity33/psslib')

import dyntools

achnf = dyntools.CHNF(outfile1); achnf.xlsout(self, channels='', show=True, xlsfile='', outfile='', sheet='', overwritesheet=True);

edit flag offensive delete link more

answered 2013-11-19 09:10:35 -0500

PieterJ gravatar image

Thank you sir! It worked great! Dyntools is indeed the way to export channel data. For xlsout, pywin32 module must be installed. This didn't work for me, but i found another command to export the channel data to a txt file: chnfobj.txtout(channels=[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22], txtfile='outfile.txt')

edit flag offensive delete link more


@PieterJ Use the function CHNF to output channel into excel and txt, but how do we know the channels =[1,2,3,4,5....] represent which channel. In other words, channel 1 represents what? Thanks!

Bob gravatar imageBob ( 2013-11-20 00:51:18 -0500 )edit

In my case, i first did a dynamic simulation (before exporting the channel data to txt file), and before starting the dyn simulation, assigned the generator speed deviations, SPEED, to chans 1 till 22. I had 22 generators. Chan 1 corresponded to SPEED of generator 1013, chan 2 to gen 2035 annd so on

PieterJ gravatar imagePieterJ ( 2013-11-20 03:59:19 -0500 )edit

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


Asked: 2013-11-18 04:18:45 -0500

Seen: 2,565 times

Last updated: Nov 19 '13