0

#EnergyPlus How to imported eio file into spreadsheet programs

According to the Documentation:The eio file or portions of it can be easily imported into spreadsheet programs and more analysis done there I tried but failed.So i wanna kown how to imported eio file into spreadsheet programs.

HE Shi's avatar
1
HE Shi
asked 2022-12-30 20:35:31 -0500
Aaron Boranian's avatar
14.1k
Aaron Boranian
updated 2023-01-04 10:16:37 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

3

The eio file is comma separated variable (csv) format and can be read by spreadsheet programs. In excel, select File/Open and browse to the eio file can click that file. You should see a pop-up like this:

image description

Make sure delimited is selected and click next. Then in the Delimiters box click comma. You can now choose Finish and the eio should open.

image description

rraustad's avatar
13.8k
rraustad
answered 2023-01-03 10:40:52 -0500
edit flag offensive 0 remove flag delete link

Comments

I also find it useful to use a text editor with book marking capabilities (e.g. textpad) to copy only the lines I'm interested in (by searching for a specific object type, name or property) and then going thorough the above procedure.

willyJohan's avatar willyJohan (2023-01-05 19:19:53 -0500) edit
add a comment see more comments