First check out:
https://spokutta.wordpress.com/the-gnu-linear-programming-kit-glpk/
and search the document for ‘excel’. Notice in their example that have a DSN.
You would need to setup an DSN that connects to Excel. If you go into Start/Windows Administrative Tools/ODBC data sources (64 bit) then select the User DSN of Excel Files, you should be able to then read tables from Excel into GMPL.
Note that if you use 64-bit GLPK, you will need to use 64-bit drivers and 64-bit Excel.
If you are using GUSEK, the default is to ship with 32-bit drivers. I replace glpsol.exe and appropriate glpk_4_xx.dll with the 64-bit version since my MS Office is 64-bit.
The important point is that your version of GLPK (32-bit or 64-bit) must match your version of Excel.
From: Help-glpk <help-glpk-bounces+marc.meketon=oliverwyman.com@gnu.org>
On Behalf Of Andrew Makhorin
Sent: Monday, September 27, 2021 8:42 PM
To: help-glpk@gnu.org
Subject: [Fwd: Guidance for import data in gusek from excel table]
-------- Forwarded Message --------
Date: Mon, 27 Sep 2021 19:33:19 -0300
Subject: Guidance for import data in gusek from excel table
Hello Team,
I wrote down a program for my final year project. The program works perfectly but I want to make sure that it will read the data from an excel file so every time I don't have to copy data from excel to gusek. But I don't know how to do
it.
Could you please help me with this?