Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel cell reference
#1
How can I get something like

A1
B1
...
Z1
AA1
AB1
...

I tried

Macro Macro5
Code:
Copy      Help
int i
str s
for i 0 100
,s.format("%c%i" 'A'+i 1)
,out s

but only works to z1...
#2
Macro Macro1546
Code:
Copy      Help
out
int i
str s
for i 0 100
,if(i<26) s.format("%c%i" 'A'+i 1)
,else s.format("%c%c%i" 'A'-1+(i/26) 'A'+(i%26) 1)
,out s
#3
Perfect!

Thanks.
#4
Other way:

Function GetExcelColumnName
Code:
Copy      Help
function~ n;;1='A'
str cn
rep
,if(n<=0) break
,n-1
,_s.format("%c" 'A'+(n%26))
,cn-_s
,n=n/26
ret cn


Forum Jump:


Users browsing this thread: 1 Guest(s)