0

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

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.

aldrin's avatar
1
aldrin
asked 2020-03-06 06:32:09 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

3 Answers

0

* 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

jconto's avatar
2.9k
jconto
answered 2020-03-09 09:42:10 -0500, updated 2020-03-10 16:41:46 -0500
edit flag offensive 0 remove flag delete link

Comments

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

perolofl's avatar perolofl (2020-03-10 01:58:19 -0500) edit

Corrected. Thanks perolofl.

jconto's avatar jconto (2020-03-10 16:42:33 -0500) edit
add a comment see more comments
0

"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).

jfconroy's avatar
186
jfconroy
answered 2020-03-11 09:18:29 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments
0

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

likethevegetable's avatar
101
likethevegetable
answered 2020-03-06 15:56:50 -0500, updated 2020-03-06 15:57:25 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer