如何解决错误：“ Excel范围的大小不良。它必须只有1行或1行。

Question

如何解决此错误？ “ Excel范围的大小不良。它必须只有1行或1行。”从CPLEX带有.csv格式的大数据的此错误发生了。

Answer 1

很难猜测发生了什么，但让我分享一个小的CSV OPL示例：

.mod

int nbKids=...;

// a tuple is like a struct in C, a class in C++ or a record in Pascal
tuple bus
{
  key int nbSeats;
  float cost;
}

// This is a tuple set
{bus} buses=...;

// asserts help make sure data is fine
assert forall(b in buses) b.nbSeats>0;
assert forall(b in buses) b.cost>0;

// decision variable array
dvar int+ nbBus[buses];

// objective
minimize
     sum(b in buses) b.cost*nbBus[b];
     
// constraints
subject to
{
   sum(b in buses) b.nbSeats*nbBus[b]>=nbKids;
}

tuple t_result
{
  key int nbSeats;
  int nb;
}

{t_result} result={<b.nbSeats,nbBus[b]> | b in buses};

.dat

/*

CSV文件是 https://github.com/alexfleischerparis/zooopl/blob/master/master/zoocsv.dat

nbseats;cost;
40;500;
30;400;

*/

nbKids=300;

// New feature in CPLEX 20.10

CSVConnection csvinput("zoobusesinput.csv?firstIsHeader=true", "");
buses from CSVRead(csvinput, "");

CSVConnection csvoutput("zoobusesoutput.csv?outputOnly=true&append=false&outputSeparator=;", "");
result to CSVPublish(csvoutput, "");