Re: [Help-glpk] Reading *.xls files

[Andrew Makhorin]

> I am a new user of GLPK and I am trying to read data from an *.xls
> file. Here is the part of dat file I am using
> 
> 
> # read data
> table data IN "ODBC" "line_data.xls": 
> LINE <- [LINE], line_id, snd_bus, rcv_bus, length, R, X, B, l_max, v1,
> v2;
> read table data;
> 
> 
> The data file work well with AMPL, but I get the following error
> message with glpsol:
> 
> 
> Reading data section from area1.dat...
> area1.dat:4: syntax error in data section
> Context:                                                        table
> MathProg model processing error
> 
> 
> I am running glpk on Ubuntu 12.04. Can anyone please point me to the
> error. Thanks

In GNU MathProg there is no read statement. Please see the language
reference (gmpl.pdf) included in the glpk distribution. See also some
examples in subdirectories glpk/examples/csv, ibid/dbf, ibid/sql.