reading and writing data from/to excel (macOS)

[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 30 times

[Fred]

Hi,

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

I hope this helps!

Fred

[Fred]

Hi,

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

I hope this helps!

Fred

[T_k]

Thank you.

How do I run a gams file from Python?