[Help-glpk] Connecting GLPK to Excel

[Aly Megahed]

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

----- Original Message -----
From: "Noli Sicad" <address@hidden>
To: "Aly Megahed" <address@hidden>
Cc: address@hidden
Sent: Tuesday, February 9, 2010 6:04:43 PM GMT -05:00 US/Canada Eastern
Subject: Re: [Help-glpk] Connecting GLPK to Excel or Access

Aly,

I suppose you have downloaded the glpk-4.42 tarball and GUSEK IDE for
GLPK/GMLP (MathProg). If not yet. I think you should download it.

http://ftp.gnu.org/gnu/glpk/

http://sourceforge.net/projects/gusek/

Are you into programming  C/C++, python, java, etc. using GLPK API
thru library (*.dll) to create your model, or more into modelling?

For modelling, use MathProg (GMPL) with GUSEK IDE. MathProg supports
to csv, dbf and sql tables. Have a look at the examples in glpk-4.42
tarball especially csv, dbf and sql.

You can easily create csv and dbf tables using Excel.  For Access, you
can SQL using ODBC connection.

Read all the postings - Re: Excel Access here:
http://www.mail-archive.com/search?q=excel+access&l=help-glpk%40gnu.org

Welcome to GLPK.

Regards, Noli

On 2/10/10, Aly Megahed <address@hidden> wrote:
>
> Hi All GLPK users,
>
> I'm a new user for GLPK, and I really need to connect it to either Excel or
> Access. I want to take the inputs (parameters values) from either Excel or
> Access, and send the model output to either Excel or Access.
>
> Is there a clear way how to do that? I read there is some .dll that connects
> to Access, but I couldn't find it, or find instructions on how to clearly
> use it.
>
> Could you please provide me with any help in that? i.e. a clear way and
> instructions on how to connect GLPK to Excel and/or Access?
>
> Thanks,
>
> Aly
>
> --
> PhD Student
> Vice President, Egyptian Student Association in North America, Georgia Tech
> Chapter
>
> Rm. 407 Main Building
> H. Milton Stewart School of Industrial and Systems Engineering
> Georgia Institute of Technology
> 765 Ferst Dr., NW
> Atlanta, Georgia 30332-0205, USA
>
>
>
>
>
>
> _______________________________________________
> Help-glpk mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/help-glpk
>

-- 
PhD Student
Vice President, Egyptian Student Association in North America, Georgia Tech 
Chapter

Rm. 407 Main Building
H. Milton Stewart School of Industrial and Systems Engineering
Georgia Institute of Technology
765 Ferst Dr., NW
Atlanta, Georgia 30332-0205, USA

-- 
PhD Student
Vice President, Egyptian Student Association in North America, Georgia Tech 
Chapter

Rm. 407 Main Building
H. Milton Stewart School of Industrial and Systems Engineering
Georgia Institute of Technology
765 Ferst Dr., NW
Atlanta, Georgia 30332-0205, USA