话不多说,直接上图
代码:
Dim C As Int32
Do
C=(ColNum-1) Mod 26
ColName=Chr(c+65) & ColName
ColNum=(ColNum-c) \ 26
Loop While ColNum>0
代码:
Dim C As Int32
Do
C=(ColNum-1) Mod 26
ColName=Chr(c+65) & ColName
ColNum=(ColNum-c) \ 26
Loop While ColNum>0