+4
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
View original
+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)
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages:
