[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Help-glpk] [Fwd: Read Excel data into subscripted set]
From: |
Andrew Makhorin |
Subject: |
[Help-glpk] [Fwd: Read Excel data into subscripted set] |
Date: |
Fri, 26 Oct 2012 17:27:51 +0400 |
-------- Forwarded Message --------
From: address@hidden
To: address@hidden
Subject: Read Excel data into subscripted set
Date: Fri, 26 Oct 2012 14:46:44 +0200
Hi,
I have troubles with reading a 2-dimensional table in MS Excel and
putting the data into a subscripted set. In a first step, I try to read
a 2-dimensional table and fill its data into a 2-dimensional parameter.
The example from the AMPL book pp.196-197 (can be found online:
http://www.ampl.com/BOOK/CHAPTERS/13-tables.pdf) describes exactly this
situation. It uses the diet problem to demonstrate, how the parameter
amt (param amt {NUTR,FOOD} >= 0) can be read from MS Excel by
table dietAmts IN "ODBX" DIET2D.xls":
[i ~ NUTR], {j in FOOD} <amt[i,j] ~ (j)>;
Since the database connection in GMPL looks a little bit different, I
adopted my working command for reading in the data of a 1-dimensional MS
Excel table to the 2-dimensional case like that:
table dietAmts IN 'ODBC'
'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,
*.xlsb)};dbq=.\test.xlsx'
'SELECT * FROM [Tabelle2$]' :
[i ~ NUTR], {j in FOOD} <amt[i,j] ~ (j)>;
Putting everything together in one model file (why the table definition
needs to be before the data part, I still do not understand..), Gusek
gives me an error message:
syntax error in field list
Context: , FOOD } >= 0 ; table dietAmts IN '...' '...' '...' : [ i ~
MathProg model processing error
I would appreciate every help!
Regards,
Christian
- [Help-glpk] [Fwd: Read Excel data into subscripted set],
Andrew Makhorin <=