论坛 › LINDO\LINGO论坛 › [求助]对于二维多数据，lingo如何从excel中读取

fly_ruc 发表于 2006-8-25 15:46

[求助]对于二维多数据，lingo如何从excel中读取

<p>对于 多维，多数据，如何读入lingo中？并请附例加以说明。多谢各位大侠了。</p>

hkkhhk 发表于 2007-8-14 12:53

<p>lingo自带一个例子就是这样的</p><p>..\Samples\WIDGETS5.lg4</p><p></p><p>MODEL:<br/>! A 6 Warehouse 8 Vendor Transportation Problem;<br/>SETS:<br/>! Import warehouses and vendors from Excel;<br/>&nbsp;&nbsp; WAREHOUSES: CAPACITY;<br/>&nbsp;&nbsp; VENDORS&nbsp;&nbsp; : DEMAND;<br/>&nbsp;&nbsp; LINKS( WAREHOUSES, VENDORS): COST, VOLUME;<br/>ENDSETS<br/>! The objective;<br/>&nbsp;&nbsp; MIN = @SUM( LINKS( I, J): <br/>&nbsp;&nbsp;&nbsp; COST( I, J) * VOLUME( I, J));<br/>! The demand constraints;<br/>&nbsp;&nbsp; @FOR( VENDORS( J): <br/>&nbsp;&nbsp;&nbsp; @SUM( WAREHOUSES( I): <br/>&nbsp;&nbsp;&nbsp;&nbsp; VOLUME( I, J)) = DEMAND( J));<br/>! The capacity constraints;<br/>&nbsp;&nbsp; @FOR( WAREHOUSES( I): <br/>&nbsp;&nbsp;&nbsp; @SUM( VENDORS( J): VOLUME( I, J)) <br/>&nbsp;&nbsp;&nbsp;&nbsp; &lt;= CAPACITY( I));<br/>DATA:<br/>! Import the data from Excel;<br/>&nbsp;&nbsp; WAREHOUSES, VENDORS, CAPACITY, DEMAND, COST = <br/>&nbsp;&nbsp;&nbsp; @OLE( '\LINGO8\SAMPLES\WIDGETS.XLS',<br/>&nbsp;&nbsp;&nbsp;&nbsp; 'WAREHOUSES', ' VENDORS', 'CAPACITY', <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'DEMAND', 'COST');<br/>! Export the solution back to Excel;<br/>&nbsp;&nbsp; @OLE( '\LINGO8\SAMPLES\WIDGETS.XLS',<br/>&nbsp;&nbsp;&nbsp; 'VOLUME') = VOLUME;<br/>ENDDATA<br/>END<br/></p>

查看完整版本: [求助]对于二维多数据，lingo如何从excel中读取