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,692 times
Last updated: Apr 04 '13
What is the base value used for the PMAX and PMIN values in REECB1 and REPCA1
Importing data from Excel and Scaling areas
How do I find dynamic model parameter ranges? Specifically wind machines
Python script for dynamics run - does it need to be improved?
dynamic simulation - linear analysis - PSS/E
Dismissing interactive prompt in python
How to return con data of a dynamic model to an array ?