Reading .out file with Excel
(I saw this posted as an answer so have moved it here as it's own question)
Hello,
I do you read the .out file in Excel? Mine is just a bunch of garbage.
Best Regards,
Madjê (@Madje)
First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!
(I saw this posted as an answer so have moved it here as it's own question)
Hello,
I do you read the .out file in Excel? Mine is just a bunch of garbage.
Best Regards,
Madjê (@Madje)
https://psspy.org/psse-help-forum/que... This question is related
It says that Excel cannot open the .out file. You must export the data to excel using excelpy
. And read the data from the .out
file using the dyntools
module.
import excelpy
import dyntools
# example getting some info from .out file
outfile = dyntools.CHNF('dynamic-results.out')
short_title, chanid_dict, chandata_dict = outfile.get_data()
# example writing to excel
xl = excelpy.workbook(xlsfile='report-file.xlsx', mode='w')
xl.set_range(1, 'a', [short_title])
xl.save()
xl.close()
Thanks you very much, this helped me a lot.
Best Regards,
Madjê
Asked: 2013-04-02 19:57:50 -0500
Seen: 3,641 times
Last updated: Apr 04 '13
excelpy Overwriting Saved data
Issue Running Dynamic Simulation in Loop, PSSEv35 vs PSSEv34
Dynamics voltage violation checks
A python script to validate and modify several model data in .dyr file ?
Synchronous generator - Power factor control, user model (.dll)
Are there any models in PSSE which can model nuclear generators?
PSSE crashing in dynamics simulation
PSSE 33.9 vs 33.10 Dynamics Simulation Results Mismatch
Running pssexcel.accc method from multiple processors simultaneously
Is it possible to make an "interface" channel in PSSE for dynamics studies?