Data exchange from excel to gams (on macOS)
Posted: Mon Jun 20, 2022 7:59 pm
Hi everyone
I would like to enter the data for parameters from an excel-file with several sheets. I created a model which seems to work with data entered in the simplest way possible but as I want to extend the model with larger data sets I need another method to integrate/include the data.
As I am working on a macOS computer i cannot use the gdxxrw method (as far as I understand it). I tried the following 3 other methods from the tutorial and documentary:
- Data Exchange with Text Files (https://www.gams.com/latest/docs/UG_Dat ... ASCII.html)
- Data Exchange with CSV2GDX (https://www.gams.com/latest/docs/T_CSV2GDX.html)
- Data Exchange with GAMS Connect (https://www.gams.com/latest/docs/UG_GAMSCONNECT.html)
Unfortunately these methods do not work on my model / computer. What method would you suggest for integrating greater data sets from excel to GAMS (on a mac computer)? Is any method advantageous compared to another one?
And sorry for the naive choice of words. I'm a newbie in GAMS and in programming in general.
I would greatly appreciate any help or hint from you. Thanks a lot in advance.
Marco
I would like to enter the data for parameters from an excel-file with several sheets. I created a model which seems to work with data entered in the simplest way possible but as I want to extend the model with larger data sets I need another method to integrate/include the data.
As I am working on a macOS computer i cannot use the gdxxrw method (as far as I understand it). I tried the following 3 other methods from the tutorial and documentary:
- Data Exchange with Text Files (https://www.gams.com/latest/docs/UG_Dat ... ASCII.html)
- Data Exchange with CSV2GDX (https://www.gams.com/latest/docs/T_CSV2GDX.html)
- Data Exchange with GAMS Connect (https://www.gams.com/latest/docs/UG_GAMSCONNECT.html)
Unfortunately these methods do not work on my model / computer. What method would you suggest for integrating greater data sets from excel to GAMS (on a mac computer)? Is any method advantageous compared to another one?
And sorry for the naive choice of words. I'm a newbie in GAMS and in programming in general.
I would greatly appreciate any help or hint from you. Thanks a lot in advance.
Marco