ExcelTalk
Table of Contents
- 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