数学建模社区-数学中国

标题: [求助]对于二维多数据，lingo如何从excel中读取 [打印本页]

作者: fly_ruc 时间: 2006-8-25 15:46
标题: [求助]对于二维多数据，lingo如何从excel中读取

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

作者: hkkhhk 时间: 2007-8-14 12:53

lingo自带一个例子就是这样的

..\Samples\WIDGETS5.lg4

MODEL:
! A 6 Warehouse 8 Vendor Transportation Problem;
SETS:
! Import warehouses and vendors from Excel;
   WAREHOUSES: CAPACITY;
   VENDORS   : DEMAND;
   LINKS( WAREHOUSES, VENDORS): COST, VOLUME;
ENDSETS
! The objective;
   MIN = @SUM( LINKS( I, J):
    COST( I, J) * VOLUME( I, J));
! The demand constraints;
   @FOR( VENDORS( J):
    @SUM( WAREHOUSES( I):
     VOLUME( I, J)) = DEMAND( J));
! The capacity constraints;
   @FOR( WAREHOUSES( I):
    @SUM( VENDORS( J): VOLUME( I, J))
     <= CAPACITY( I));
DATA:
! Import the data from Excel;
   WAREHOUSES, VENDORS, CAPACITY, DEMAND, COST =
    @OLE( '\LINGO8\SAMPLES\WIDGETS.XLS',
     'WAREHOUSES', ' VENDORS', 'CAPACITY',
      'DEMAND', 'COST');
! Export the solution back to Excel;
   @OLE( '\LINGO8\SAMPLES\WIDGETS.XLS',
    'VOLUME') = VOLUME;
ENDDATA
END

欢迎光临数学建模社区-数学中国 (http://www.madio.net/)