Page 1 of 1

reading and writing data from/to excel (macOS)

Posted: Thu Nov 17, 2022 8:04 am
by T_k
Hello,

I am using GAMS on macOS. How can I read/write data from/to an excel file? For example, attached is a classic example from GAMS model library. How can I export the solution variables to an excel file? How can I read the parameter values from an excel file?
transport.gms
(1.71 KiB) Downloaded 251 times

Re: reading and writing data from/to excel (macOS)

Posted: Thu Dec 22, 2022 3:54 pm
by Fred
Hi,

You could use GAMS Connect which can read/write Excel files and is platform independent.

I hope this helps!

Fred

Re: reading and writing data from/to excel (macOS)

Posted: Thu Dec 22, 2022 3:56 pm
by Fred
Hi,

You could use GAMS Connect which can read/write Excel files and is platform independent.

I hope this helps!

Fred

Re: reading and writing data from/to excel (macOS)

Posted: Sat Jan 28, 2023 7:53 am
by T_k
Thank you.

How do I run a gams file from Python?

Re: reading and writing data from/to excel (macOS)

Posted: Thu Feb 09, 2023 7:27 am
by bussieck
How do I run a gams file from Python?
Is this related to the previous question or a complete new one? In the former case make sure we understand the connection and in the latter make a new topic and also provide more info.

-Michael