Solved

Convert LastUsedColumnNumber to Excel letter-representation

  • 15 March 2022
  • 1 reply
  • 11 views

Badge +4
  • AIMMS 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!

icon

Best answer by gdiepen 15 March 2022, 16:09

View original

1 reply

Userlevel 4
Badge +7

You can convert it from the numerical representation to the letter-representation using the axll::ColumnName function (see https://how-to.aimms.com/Articles/228/228-data-ranges.html#axll-functions)

Reply


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

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