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 and the Data Exchange Library.

Function Spreadsheet::ColumnName(ColumnNumber)

Spreadsheet::ColumnName

The function Spreadsheet::ColumnName returns the name of the Excel or OpenOffice Calc column with the given number.

Spreadsheet::ColumnName(
        ColumnNumber  ! (input) scalar numerical expression
        )

Arguments

ColumnNumber

A scalar integer expression representing the column number for which to determine the name.

Return Value

The function returns a string representing the column name corresponding to the ColumnNumber. If it fails, AIMMS issues an error message and execution is halted.

Note

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

See also