如何解决错误："excel range has bad size. it must be only 1 line or 1 row"

Question

如何解决此错误?excel范围大小不合适。它必须只有一行或一行。"对于csv格式的Cplex的大数据，出现此错误。

Answer 1

很难猜到发生了什么，但让我分享一个小的csv OPL示例:

。国防部https://github.com/AlexFleischerParis/zooopl/blob/master/zoocsv.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/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, "");