Re: [Help-glpk] Connecting GLPK to Excel

[xypron]

Hello Aly,

GLPK can read csv files, see examples/csv/transp_csv.mod and doc/tables.pdf
in GLPK 4.43.
GLPK expect the decimal delimitor to be a point and the field separator to
be a comma.
If Excel does not save in this format you may change your Windows region
settings to
Englisch/USA.

You can use ODBC to connect to Excel.
https://winglpk.svn.sourceforge.net/svnroot/winglpk/trunk/examples/sql/
has an example.
My Windows XP ODBC driver only supported the Excel 97 format.

Best regards

Xypron


Aly Megahed wrote:
> 
> Hi All,
> 
> I hope you are doing well. Your previous help concerning the details of
> connecting GLPK/MathProg to Access worked greatly.
> 
> Now, do you mind writing me (and all users) detailed instructions and an
> example of how to connect it to Excel (either through that csv or dbf, or
> whatever) in order to be able to get data from Excel and send variable
> values back there?
> 
> I use GLPK_4_41.dll and glpsol.exe.
> 
> Your help is greatly appreciated.
> 
> Best,
> 
> Aly
> 

-- 
View this message in context: 
http://old.nabble.com/Connecting-GLPK-to-Excel-tp28349592p28350459.html
Sent from the Gnu - GLPK - Help mailing list archive at Nabble.com.