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.
"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).
* 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
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
Asked: 2020-03-06 06:32:09 -0500
Seen: 876 times
Last updated: Mar 11 '20
whit loves you. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
