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::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.