Using GAMS on Mac OS X Environment with Wine bottler

Problems with syntax of GAMS
rfciii
User
User
Posts: 2
Joined: 9 months ago

Re: Using GAMS on Mac OS X Environment with Wine bottler

Post by rfciii » 9 months ago

Hi Renger - I am in similar wineGAMS situation and appreciate your help thus far.

I don't see how to add MS excel path to gdxxrw command. I've looked in GAMS User guide and searched web.

Putting an excel shortcut in gamsdir/projdir doesn't seem to help.

I'm happy to use XLSDump or other workaround; just am unsure of what are practical approaches in wineGAMS.

I am running wineGAMS 25.0.2 r65345 32-bit on Mac OS X 10.11.6.

Thanks in advance!

Best,
Robert

rfciii
User
User
Posts: 2
Joined: 9 months ago

Re: Using GAMS on Mac OS X Environment with Wine bottler

Post by rfciii » 9 months ago

Correction to my last post.

Yes, my .xls file is in the gamsdir/projdir directory.

Per below, the error I am getting indicates wineGAMS can't find MS Excel on my mac... How do I fix this, please?

GDXXRW 25.0.2 r65346 Released Jan 31 2018 VS8 x86 32bit/MS Windows
Cannot create an instance of Excel: Error = OLE error 800401F3, ProgID: "Excel.Application"
Check that Excel is installed correctly.
In case you use the "Click-to-Run" version of Excel, uninstall
this version and install the regular version.
**** Problem opening Excel: Cannot create an instance of Excel: Error = OLE error 800401F3, ProgID: "Excel.Application"
Total time = 52 Ms

Thanks in advance!

Jarenka
User
User
Posts: 27
Joined: 5 months ago

Re: Using GAMS on Mac OS X Environment with Wine bottler

Post by Jarenka » 2 months ago

bussieck wrote:
10 months ago
Hi,

GAMS Studio is about to be released (in a month or two) in it's first version (see viewtopic.php?f=8&t=10198#p23354). In the meantime you might want to check the contributed software page with some alternative UI for GAMS: https://www.gams.com/community/contributed-software/ some of them for the Mac.

Hope this helps,
-Michael
Dear,
Maybe it is a stupid question, but where can I find a link to install GAMS Studio?

All the best
irena


Jarenka
User
User
Posts: 27
Joined: 5 months ago

Re: Using GAMS on Mac OS X Environment with Wine bottler

Post by Jarenka » 2 months ago

bussieck wrote:
2 months ago
www.gams.com/download

-Michael
I just wanted to say that I found it. Thank you Michael !!

Post Reply