Question-and-Answer Resource for the Building Energy Modeling Community
 | 1 | initial version |
For EnergyPlus output processing, when I need to gather information from tabular reports from a lot of files, I use the current XML output option:
OutputControl:Table:Style,
XMLandHTML: !- Column Separator
and a Python script called epXML2CSV.py that reads the XML output from every file in a folder and creates a CSV file that can then be imported into a spreadsheet program like Excel. It reads only parts of the tabular report that you want based on list in a text files. The script and example file are at:
Suggestions on how to improve the script are welcome.
| | 2 | No.2 Revision |
For EnergyPlus output processing, when I need to gather information from tabular reports from a lot of files, I use the current XML output option:
OutputControl:Table:Style,
XMLandHTML: !- Column Separator
and a Python script called epXML2CSV.py that reads the XML output from every file in a folder and creates a CSV file that can then be imported into a spreadsheet program like Excel. It reads only parts of the tabular report that you want based on list in a text files. The script and example file are at:
link to epXML2CSV.zipepXML2CSV GitHub repo
Suggestions on how to improve the script are welcome.
