0

I have a parameter with 4 dimensions which I would like to import in Excel.

Currently I have a series of Excel sheets with each over 500,000 rows. The columns are:

  • Parcel,
  • Farm,
  • Year,
  • Species,
  • Class,
  • Surface

Ideally I would like to have a parameter in GAMS like: Surface(Parcel,Farm,Year,Species,Class)

Is there an elegant way to do this?

Serj-Tm
  • 16,581
  • 4
  • 54
  • 61
LouisM
  • 1

1 Answers1

0

Problem solved.

For those interested, the solution is as simple as this:

$CALL GDXXRW.EXE DeParcels2012_GAMS.xlsx par=input2012  rdim=5

The number of dimensions can be specified in the gdxxrw tool.

LouisM
  • 1