Function Spreadsheet::ColumnNumber(ColumnName)

Spreadsheet::ColumnNumber

Warning

Spreadsheet Functions are deprecated. One may use the AIMMS Excel Library - AXLL or the Data Exchange Library.

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.