' 将数字计数的列号转换成excel中的列名, n, 待转换的列号, 从1开始
function getcolname(n)
dim mystring, myarray
mystring = "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z"
myarray = split(mystring, ",")
if (n-1)<26 then
getcolname = myarray(n-1)
else
if (n mod 26) > 0 then
getcolname = myarray(n\26-1)&myarray((n mod 26)-1)
else
if (n\26) > 1 then
getcolname = myarray(n\26-2)&"z"
else
getcolname = myarray(n\26-1)&"z"
end if
end if
end if
end function
function getcolname(n)
if (n-1)<26 then
getcolname = chr(64+n)
else
getcolname = chr(64+(n\26))&chr(64+(n mod 26))
end if
end function
6
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!
网友评论