Procedure Spreadsheet::SaveWorkbook(Workbook, SaveAsName)

Spreadsheet::SaveWorkbook

Warning

Spreadsheet Functions are deprecated. One may use the AIMMS Excel Library - AXLL or the Data Exchange Library.

The procedure Spreadsheet::SaveWorkbook saves the specified Excel or OpenOffice Calc workbook. The workbook is saved with the name under which it is known in AIMMS, unless the SaveAsName argument is specified. Only when the SaveAsName argument is specified, or when dealing with a workbook that has never been saved before (i.e. created by a call to Spreadsheet::CreateWorkbook), and a workbook with the same name already exists on disk, the user is prompted with the question whether or not to overwrite the existing file.

Spreadsheet::SaveWorkbook(
        Workbook,       ! (input) scalar string expression
        [SaveAsName]    ! (optional) scalar string expression
        )

Arguments

Workbook

A scalar string expression representing the Excel or Calc workbook. If this argument ends in .ods, OpenOffice Calc is used. Otherwise, Excel is

SaveAsName

The (new) name to be used for saving the workbook.

Return Value

The procedure returns 1 on success, or 0 otherwise. In case of an error the pre-defined AIMMS parameter CurrentErrorMessage contains a description of what went wrong.

Note

• Upto AIMMS 3.11 this function was known as ExcelSaveWorkbook, which has become deprecated as of AIMMS 3.12.