Spreadsheet Functions

Warning

As detailed in the AIMMS Product Lifecycle, Spreadsheet Functions are deprecated.

One may use the AIMMS Excel Library - AXLL or the Data Exchange Library.

AIMMS supports the following functions for reading from and writing to Excel and OpenOffice Calc workbooks:

• Spreadsheet::ColumnName
• Spreadsheet::ColumnNumber
• Spreadsheet::SetActiveSheet
• Spreadsheet::SetVisibility
• Spreadsheet::AssignValue
• Spreadsheet::SetOption
• Spreadsheet::SetUpdateLinksBehavior
• Spreadsheet::AssignSet
• Spreadsheet::RetrieveSet
• Spreadsheet::RetrieveValue
• Spreadsheet::AssignParameter
• Spreadsheet::RetrieveParameter
• Spreadsheet::AssignTable
• Spreadsheet::ClearRange
• Spreadsheet::RetrieveTable
• Spreadsheet::AddNewSheet
• Spreadsheet::CopyRange
• Spreadsheet::DeleteSheet
• Spreadsheet::GetAllSheets
• Spreadsheet::RunMacro
• Spreadsheet::CloseWorkbook
• Spreadsheet::CreateWorkbook
• Spreadsheet::SaveWorkbook
• Spreadsheet::Print

The functions operate on OpenOffice Calc workbooks, if the WorkbookName argument ends in .ods. In all other cases, the functions operate on Excel workbooks.