reading and writing data from/to excel (macOS)

questions about GAMS' tools
Post Reply
T_k
User
User
Posts: 6
Joined: 2 months ago

reading and writing data from/to excel (macOS)

Post by T_k » 2 months ago

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
Posts: 340
Joined: 6 years ago

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

Post by Fred » 1 month ago

Hi,

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

I hope this helps!

Fred

Fred
Posts: 340
Joined: 6 years ago

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

Post by Fred » 1 month ago

Hi,

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

I hope this helps!

Fred

T_k
User
User
Posts: 6
Joined: 2 months ago

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

Post by T_k » 22 hours ago

Thank you.

How do I run a gams file from Python?

Post Reply