Dear researchers,
I have the following questions:
1. I want to know how I can read a number of TABLES and PARAMETERS from excel?
2. How can I make GAMS show the zero values as "0" in the results? Obviously, the program drops them...
I know how to convert one table or parameter from GAMS to excel. When I use 'xls2gms' or 'gdxxrw', it is ok but just for one table, for example.
However, in my case study, there is a sheet that contains many tables, and I don't know how to convert them to the assigned table names in GAMS. The ide shows an error with this regard!
Thanks for your help in advance.
Dear Hooman Firoozi ;
GAMS can communicate with Microsoft Excel via GDX (GAMS Data Exchange) files. In order to write data from GAMS and to Excel, selected GAMS data can be written into a GDX file and then to an Excel file: GAMS -> GDX -> Excel. Similarly selected Excel data can be written to a GDX file and then read into GAMS: Excel -> GDX -> GAMS.
Best regards
Dear Hooman,
Its an interesting question i also worked on it one year ago, but here its difficult for me to explain the full procedure to convert sheets from Excel to General Algebraic Modelling System (GAMS), here is the link for full detailed procedure kindly follow it. And after that if you have any query then kindly contact me i will help you with my best. Thanks.
https://www.gams.com/latest/docs/UG_DataExchange_Excel.html#UG_DataExchange_Excel_ExcelToGAMS_GDX
Dear Hooman
This link may help you: https://www.mathworks.com/matlabcentral/answers/127873-how-to-read-values-from-a-table-or-excel-file-and-assign-it-to-a-variable
Dear Zia Hameed
Thanks for your answer. Do you know the answer to the second question?
Dear Hooman Firoozi ;
GAMS can communicate with Microsoft Excel via GDX (GAMS Data Exchange) files. In order to write data from GAMS and to Excel, selected GAMS data can be written into a GDX file and then to an Excel file: GAMS -> GDX -> Excel. Similarly selected Excel data can be written to a GDX file and then read into GAMS: Excel -> GDX -> GAMS.
Best regards
- Badges
- Science topic