reading and writing data from/to excel (macOS)

questions about GAMS' tools
Post Reply
T_k
User
User
Posts: 8
Joined: 1 year ago

reading and writing data from/to excel (macOS)

Post 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 168 times
Fred
Posts: 372
Joined: 7 years ago

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

Post by Fred »

Hi,

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

I hope this helps!

Fred
Fred
Posts: 372
Joined: 7 years ago

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

Post by Fred »

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: 8
Joined: 1 year ago

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

Post by T_k »

Thank you.

How do I run a gams file from Python?
User avatar
bussieck
Moderator
Moderator
Posts: 1033
Joined: 7 years ago

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

Post 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
Post Reply