0

exporting dynamic simulation results to excel using python

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!

Pieter

PieterJ's avatar
1
PieterJ
asked 2013-11-18 04:18:45 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

1

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);

yfwing's avatar
436
yfwing
answered 2013-11-18 11:29:13 -0500
edit flag offensive 0 remove flag delete link

Comments

Hey,my bro.I want to know the dyntools in detail.I have PSSE V34.But I do not find dyntools.I find dyntools_demos.Are dyntools and dyntools_demo the same files?And dyntools_demo in PSSE V34 do not have attribute 'CHNF'.What should I do?

David's avatar David (2021-07-13 01:52:43 -0500) edit
add a comment see more comments
0

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')

PieterJ's avatar
1
PieterJ
answered 2013-11-19 09:10:35 -0500
edit flag offensive 0 remove flag delete link

Comments

@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's avatar Bob (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's avatar PieterJ (2013-11-20 03:59:19 -0500) edit

You can refer to the PDF file named API.This file you can find it in DOCS folder.

David's avatar David (2021-07-13 01:46:32 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer