reading and writing data from/to excel (macOS)

GAMS
1

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 KB)

2

Hi,

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

I hope this helps!

Fred

3

Hi,

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

I hope this helps!

Fred

4

Thank you.

How do I run a gams file from Python?

5

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

6

Thanks for the information!