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 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
To: help-glpk@gnu.org<mailto:help-glpk@gnu.org>
From: Sagarkumar Patel
mailto:sagarkumar%20patel%20%3csagarcpatel.l...@gmail.com%3e>>
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?
Regards,
Sagar Patel
This e-mail and any attachments may be confidential or legally privileged. If
you received this message in error or are not the intended recipient, you
should destroy the e-mail message and any attachments or copies, and you are
prohibited from retaining, distributing, disclosing or using any information
contained herein. Please inform us of the erroneous delivery by return e-mail.
Thank you for your cooperation.