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.


Command line:

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

Compile time:

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

Execution time:

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

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