Hi
I am trying to copy data from the excel sheet with dimension of (40*48) but while copying the data are not align …How can i align for the large table like this …
Hi
It is never a good idea to copy-paste stuff. If you change your table, you have to do it again, and again.
I would suggest that you use gdxxrw to read the table in your code directly.
If that is not an option, you can save your table from excel into a csv-file and read it with csv2gdx.
Cheers
Renger
Thank you Renger
I am new so can i know how to read from excel to GAMS .I try doing my self stdy but i confused with so many ideas …which to follow …I am attaching my excel file where there are the data’s so could you please guide with the most standard method to copy it to GAMS
To Gams .xlsx (20.6 KB)
EvToGams.xlsx (20.6 KB)
This is my excel sheet …How can i copy to the GAMS . I am going through the GDXRW but so many options are given i am getting confused which is best suited to my data as i have data for 40 EVS along rows and 48 time interval in column and i have to copy the parameters also .
I am attaching my excel file …if somebody can help …it would be greatful …
Hi
Your tables are all two-dimensional tables, so not many options needed. Work through the examples in the GDXXR documentation (unfortunately, it starts with all options. It is better to start with the examples and if you encounter more difficult tables/problem, you can look through the settings).
Cheers
Renger
GDXXR ??
gdxxrw