Function Spreadsheet::ColumnNumber(ColumnName)

Spreadsheet::ColumnNumber

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

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

Arguments

ColumnName

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

Return Value

The function returns an integer representing the column number corresponding to the ColumnName. If it fails, AIMMS issues an error message and execution is halted.

Note

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

See also

The function Spreadsheet::ColumnName.