- Procedure Spreadsheet::DeleteSheet(Workbook, Name)¶
Spreadsheet::DeleteSheet deletes the given sheet from
the specified Excel or OpenOffice Calc workbook.
Spreadsheet::DeleteSheet( Workbook, ! (input) scalar string expression Name ! (input) scalar string expression )
A scalar string expression representing the Excel or Calc workbook. If this argument ends in
.ods, OpenOffice Calc is used. Otherwise, Excel is
The name of the sheet to be deleted.
The procedure returns 1 on success, or 0 otherwise. In case of an error the pre-defined AIMMS parameter
CurrentErrorMessagecontains a description of what went wrong.
Upto AIMMS 3.11 this function was known as
ExcelDeleteSheet, which has become deprecated as of AIMMS 3.12.