Export AREA LOSSES from the output bar to Excel

asked 2022-02-17 14:07:01 -0500

hleen
1 ●1 ●1 ●1

Hi,

I am new to using PSSE, and I was wondering if there is a way to export the area losses which are displayed in the output bar when we run the Area/Owner/Zone Total reports for a particular area.

Right now I run the report for each area individually and enter the loss manually in excel. It would be great if there was script that automatically runs each area and picks the loss associated with it and exports that number to excel.

Thanks.

edit retag flag offensive close merge delete

add a comment

0

answered 2022-02-21 11:10:54 -0500

perolofl

2947 ●1 ●8 ●16

There are several different modules available that can write to an excel file. I often use openpyxl to write results from PSSE to Excel.

edit flag offensive delete link

Comments

Hi, Thanks for the suggestion. I currently use openpyxl for excel scripts. I guess I wasn't clear in my question, I need help with the command/syntax to get output bar results exported from PSSE to Excel. I f you have any suggestions regarding that please let me know.

hleen ( 2022-02-22 12:32:50 -0500 )edit

Write the report to a file, using report_output, as Anil proposed and then read the file and write relevant infomation to Excel with openpyxl.

perolofl ( 2022-02-23 02:30:56 -0500 )edit

add a comment

0

answered 2022-02-19 04:43:48 -0500

Anil Kumar
1 ●1 ●3 ●2

you can export report screen to text file using the command as follows

psspy.report_output(2, "check_all", 2) #### rending report to external txt file

psspy.report_output(1, "check_all", 2)  ### sending report to internal report screen of psse