1

Make a simulation results extractor from equest to excel

Hello, I wonder how to start to automatically extract simulation results from equest. I wanna export results to excel. I need to make a macro/program for it.

Thanks

Chriskab's avatar
57
Chriskab
asked 2018-10-27 08:07:31 -0500
__AmirRoth__'s avatar
4.4k
__AmirRoth__
updated 2018-10-27 12:38:00 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

3

I have a Python repository on my GitHub with a few modules for eQuest file parsing. Most of the 'sim_parse' files will run as scripts and pull out specific reports into csv files for all sim files in the folder from which they are run.

mikesweeney's avatar
493
mikesweeney
answered 2019-01-25 09:56:55 -0500, updated 2020-09-02 18:31:24 -0500
edit flag offensive 0 remove flag delete link

Comments

1

Thanks for sharing this

JasonGlazer's avatar JasonGlazer (2019-01-25 10:01:23 -0500) edit
3

I have an outdated one here too: https://github.com/jmarrec/eQSimParsing

Julien Marrec's avatar Julien Marrec (2019-01-25 10:37:34 -0500) edit

Thanks Mike and Julien. I tried adding a .sim file and executed all .py files but no results appear to be shown or any .csv files. Am I missing anything here?

BilalMaarouf's avatar BilalMaarouf (2019-01-27 01:03:49 -0500) edit

I assume you've installed Python and all dependencies? if so, maybe take a look at the results in Jupyter, or an IDE like Spyder or PyCharm in order to get a sense of why the .csv files aren't generating?

mikesweeney's avatar mikesweeney (2019-01-28 10:36:24 -0500) edit

For mine, run the eQSimParsing demonstration.ipynb notebook (type jupyter notebook in a terminal (CMD) in a folder that's above the folder that has the jupyter notebook, but isn't the root of your drive, then open the notebook in the navigation that popped up in your browser, and remember that to execute cells of code you have to do CTRL+ENTER). My parsing thingy loads stuff inside pandas dataframe, which happen to have a to_csv and a to_excel function. I usually just plot the results and stuff like that right in Python, but exporting to CSV/Excel is just as easy.

Julien Marrec's avatar Julien Marrec (2019-01-29 01:55:26 -0500) edit
add a comment see more comments
2

I'd suggest you to take a look at the D2Result.dll. Here's a example.

Jeremy's avatar
1.6k
Jeremy
answered 2019-01-21 11:57:20 -0500, updated 2019-01-21 13:48:18 -0500
edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments