1、導入Excel的語法結構

Execute_Unload ‘filename.gdx’,data_name
Execute ‘Gdxxrw.exe filename.gdx O = filename.xls data_type = data_name Rng = Excel spreadsheet!’

語法解釋

第一行表示創建一個gdx文件，“filename”是你給gdx文件起的名字，“data_name”是你想輸出的數據名字；
第二行表示將創建的gdx文件轉化為xls文件，O的意思是“output to”，之后定義你輸出的數據的類型（var，par···），Rng表示范圍，就是你輸出的數據在Excel表格中的范圍，比如sheet1的a1到d4（sheet1!a1:d4）

2、算例

Title The Transportation Problem of Linear ProgrammingSetsi *canning plants* / Seattle, San-Diego /j *markets* / New-York, Chicago, Detroit /;Parametersa(i) *capacity of plant i in cases*/ Seattle 350San-Diego 600 /b(j) *demand at market j in cases*/ New-York 325Chicago 300Detroit 275 /;Table d(i,j) *distance in thousands of miles*New-York ChicagoDetroitSeattle 2.5 1.71.8San-Diego 2.5 1.81.4;Scalar f *freight in dollars per case per thousand miles* /90/;Parameter c(i,j) *transport cost in 1000s of dollars per case*;c(i,j) = f*d(i,j)/1000;Variablesx(i,j) *shipment quantities in cases*z *total transportation costs in 1000s of dollars*;Positive variable x;Equationscost *define objective function*supply(i) *observe supply limit at plant i*demand(j) *satisfy demand at market j* ;cost.. z =e= sum((i,j), c(i,j)*x(i,j));supply(i) .. sum(j, x(i,j)) =l= a(i);demand(j) .. sum(i, x(i,j)) =g= b(j);Model transport /all/;Solve transport using lp minimizing z;Display x.l, x.m ; Execute_Unload 'transport.gdx', c, x, z;Execute 'Gdxxrw transport.gdx O = transport.xls par = c Rng =Sheet1!a1:d3';Execute 'Gdxxrw transport.gdx O = transport.xls var = x Rng =Sheet1!a5:d7';Execute 'Gdxxrw transport.gdx O = transport.xls var = z Rng = Sheet1!e8'

;

總結

以上是生活随笔為你收集整理的GAMS计算结果输出到Excel表格的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。