1

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)

JervisW's avatar
1.3k
JervisW
asked 2013-04-02 19:57:50 -0500, updated 2013-04-02 20:00:33 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

4

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()
JervisW's avatar
1.3k
JervisW
answered 2013-04-02 20:11:51 -0500
edit flag offensive 0 remove flag delete link

Comments

@Madje this is for you

jtrain's avatar jtrain (2013-04-02 20:13:39 -0500) edit
add a comment see more comments
0

Thanks you very much, this helped me a lot.

Best Regards,

Madjê

Madje's avatar
1
Madje
answered 2013-04-04 03:24:35 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

Your Answer

Login/Signup to Answer