Ask Your Question
1

Reading .out file with Excel

asked 2013-04-02 19:57:50 -0500

JervisW gravatar image

updated 2013-04-02 20:00:33 -0500

(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)

edit retag flag offensive close merge delete

2 answers

Sort by » oldest newest most voted
4

answered 2013-04-02 20:11:51 -0500

JervisW gravatar image

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()
edit flag offensive delete link more

Comments

@Madje this is for you

jtrain gravatar imagejtrain ( 2013-04-02 20:13:39 -0500 )edit
0

answered 2013-04-04 03:24:35 -0500

Madje gravatar image

Thanks you very much, this helped me a lot.

Best Regards,

Madjê

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

[hide preview]

Question Tools

1 follower

Stats

Asked: 2013-04-02 19:57:50 -0500

Seen: 3,639 times

Last updated: Apr 04 '13