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 [-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