ExcelTalk

Note
This tool is part of the GAMS Tools Library. Please inspect the general information about GAMS Tools.

Performs command on an Excel workbook specified by filename.

Usage

Command line:

gamstool [win32.]ExcelTalk command filename [quit=0|1]

Compile time:

$callTool [win32.]ExcelTalk command filename [quit=0|1]

Execution time:

executeTool '[win32.]ExcelTalk command filename [quit=0|1]';

The following commands are recognized:

Command Description
close Close workbook ignoring changes.
open Opens workbook.
saveAndClose Ask Excel to save & close the workbook.


The following named parameter is available:

Argument Description
quit=0 or 1 Determines if Excel program should be terminated or not (default: 0).

Example: Save and close an Excel workbook

$callTool win32.ExcelTalk saveAndClose myFile.xlsx