Ask Your Question
0

Where can i find the different functions that I can use to export data from PSSE to excel?

asked 2020-03-06 06:32:09 -0500

aldrin gravatar image

Hello, I watched the video about exporting data from PSSE to excel. Where can I find the different functions that I can use to export not just the bus numbers and voltage? Thanks.

edit retag flag offensive close merge delete

3 answers

Sort by » oldest newest most voted
0

answered 2020-03-11 09:18:29 -0500

jfconroy gravatar image

"The pssexcel module provides Python functions to export PSS ®E data or solution results to Excel spreadsheets."

"The excelpy module provides Python functions to interface with Excel. Use this module to create, populate and format Excel workbooks from Python."

The pssexcel module exports results files in PSS/E format to Excel, whereas excelpy is a more "general purpose" module for exchanging data between PSS/E and Excel. I suspect that it is excelpy that you want. You could use openpyxl instead of excelpy, but I find that excelpy has all of the functionality that I want, and it is included with PSS/E so there's no need to do an additional python module installation (as with openpyxl).

edit flag offensive delete link more
0

answered 2020-03-09 09:42:10 -0500

jconto gravatar image

updated 2020-03-10 16:41:46 -0500

* print embedded module help text *

Almost all modules installed with PSSe contain embedded information. One way to print to a CMD window is:

# moduledoc.py
import os,sys
import psse33
import pssexcel
print help(pssexcel)

save the above code as moduledoc.py and run it inside a CMD window. To save it to file type: [in a CMD window]..c:..>python moduledoc.py > pssexcel_doc.txt

edit flag offensive delete link more

Comments

You got it wrong on the last line. It shall be "print help(pssexcel)"

perolofl gravatar imageperolofl ( 2020-03-10 01:58:19 -0500 )edit

Corrected. Thanks perolofl.

jconto gravatar imagejconto ( 2020-03-10 16:42:33 -0500 )edit
0

answered 2020-03-06 15:56:50 -0500

kewasiuk gravatar image

updated 2020-03-06 15:57:25 -0500

There is a built in pssexcel module that comes with PSS/E. I prefer using the openpyxl module. It's as simple as storing what you want in a python list, opening an Excel workbook, printing your data into the cells, and saving. Unfortunately I can't find any substantial documentation of pssexcel

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: 2020-03-06 06:32:09 -0500

Seen: 199 times

Last updated: Mar 11