Procedure Spreadsheet::SetVisibility(Workbook, Visibility)

Spreadsheet::SetVisibility

Warning

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

The procedure Spreadsheet::SetVisibility turns the visibility mode of the given Excel or OpenOffice Calc workbook on or off.

Spreadsheet::SetVisibility(
        Workbook,       ! (input) scalar string expression
        Visibility      ! (input) scalar element 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

Visibility

A scalar element expression in the pre-defined AIMMS set OnOff specifying whether to show or hide the specified workbook.

Return Value

The procedure returns 1 on success, or 0 otherwise.

Note

  • If the workbook is not yet open, it will be opened.

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