First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered Apr 3 '13

JervisW gravatar image

https://psspy.org/psse-help-forum/question/668/out-output-file-excel/ 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()