今天碰到的题目,当时不会。回来想了一会,调试了一下,然后想上网对答案,发现竟然没有!!!
function str(num){if(num<=0){alert(“excel表格貌似没有负数吧”);return 0;}if(num>26){var newnum1 = parseInt(num/26);var newnum2 = num%26;var newnum1str,newnum2str = null;if(!newnum2){newnum1str=str(newnum1-1);newnum2str=”Z”;}else{newnum1str=str(newnum1);newnum2str=str(newnum2);}return newnum1str+newnum2str;} var az=”ABCDEFGHIJKLMNOPQRSTUVWXYZ”;var arr = az.split(“”);for(var i = 0;i<=arr.length;i++){if(num==i){return arr[i-1];}}}拿去玩,拿去玩, \(^o^)/ 留个赞呗