First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

Ask Your Question
0

How can I get only certain channels from .out file to excel? e.g only angles

asked May 23 '17

mitrax1p gravatar image

I have a .out file which has all the monitored channels. How can I just get the angles out in an xls file

2 answers

Sort by » oldest newest most voted
0

answered Jun 9 '17

jconto gravatar image

updated Aug 9 '17

I have written a python code that uses dyntools to export any type of channels the user select to an excel file.

You can download the code with a PSSe v.33 demo set from [copy the link into your browser]:

“https://drive.google.com/drive/folders/0B7uS9L2Woq7YzYzcGhXT2VQYXc” Once you select “channelsxxxxx.zip”, an icon on the top-center screen will perform the download.

Once downloaded & unzipped, open a DOS window on this channels' folder and run the following [it will export volt channels]: c:..>channels chan_V_exp

Follow the instruction in the read.me file to run the other demos included.

link
0

answered May 25 '17

perolofl gravatar image

It is possible to export your own selection of channels from an out-file: Select your channels in "Plot Tree View", right-click and select "Export to Excel". The excel file always get the same name as the out-file.

link

Comments

HI, thanks for the response. I automated the plotting process using dyntools in python. So I can plot the required stuff directly through python

mitrax1p gravatar imagemitrax1p (May 25 '17)

FYI using dyntools, the "xlsout" function can also be used to generate an excel file from a .out file.

oppossumX gravatar imageoppossumX (May 29 '17)

@oppossumX was quit right

Linzhi gravatar imageLinzhi (Jul 7 '17)

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.
Want to format code in your answer? Here is a one minute demo on Youtube

Add Answer

[hide preview]

Question Tools

Stats

Asked: May 23 '17

Seen: 431 times

Last updated: Aug 09 '17