Convert LastUsedColumnNumber to Excel letter-representation

  • 15 March 2022
  • 1 reply

Badge +4
  • AIMMS Implementation Partner
  • 12 replies

In version 4.71.4, I tried to use the LastUsedColumnNumber, and as the name already gives away it returns a number while I had hoped for a column name in the range of 1 to “ZZZ” like the ones that Excel uses. This would make it easier to also used it in the column/data range definition when reading data.

Can anyone advice on how to easily/efficiently translate this?

Thanks in advance!


Best answer by gdiepen 15 March 2022, 16:09

View original

1 reply

Userlevel 5
Badge +7

You can convert it from the numerical representation to the letter-representation using the axll::ColumnName function (see


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator