Function Spreadsheet::ColumnName(ColumnNumber)

Spreadsheet::ColumnName

Warning

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

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

The function Spreadsheet::ColumnNumber.