Warning

This article references outdated technology and is provided for historical purposes only. It is not recommended to use this information as a primary source for current projects or documentation. Please refer to the latest documentation for up-to-date information, see more in: AIMMSXL Library (AXLL) and the Data Exchange Library.

Spreadsheet Functions

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

Note

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