\u5728\u532f\u5165Excel\u7684\u6642\u5019\uff0c\u56e0\u70ba\u8b80\u53d6\u5230\u7684Col\u70ba\u82f1\u6587\u6a19\u793a\uff0c\u770b\u8d77\u4f86\u50cf\u662f26\u9032\u4f4d\uff0c\u4f46\u662f\u662fA~Z\u4f86\u8868\u793aA=1, B=2,C=3….Z=0…AA=27…<\/p>\n
\u6240\u4ee5\u532f\u5165\u7684\u6642\u5019\uff0c\u8981\u8b80\u884c\u9700\u900f\u904e\u7279\u6b8a\u8f49\u63db<\/p>\n
\u5e95\u4e0b\u662f\u6211\u81ea\u5df1\u60f3\u7684\u7a0b\u5f0f\u78bc\uff0c\u5206\u4eab\u7d66\u4f86\u53c3\u8003\u7684\u4eba<\/p>\n
<?php<\/p>\n
\/\/Test
\nfor($j=26; $j<=1090; $j=$j+26){
\n$d = excel_num_to_col($j);
\necho “$j”;
\nprint_r($d);
\n}<\/p>\n
\/\/\u6578\u5b57\u8f49\u82f1\u6587
\nfunction excel_num_to_col($num){
\nfor($i=$num; $i>0; $i=($i%26==0)?intval($i\/26)-1:intval($i\/26)){
\n$result[] = num_az($i%26);
\n}
\nreturn array_reverse($result);
\n}<\/p>\n
\/\/\u82f1\u6587\u8f49\u6578\u5b57
\nfunction excel_col_to_num($str){
\n$arr = array_reverse(str_split($str));
\nforeach((array)$arr as $key => $val){
\n$result += pow(26, $key)*az_num($val);
\n}
\nreturn $result;
\n}<\/p>\n
\/\/\u82f1\u6587\u8f49\u6578\u5b57\u5c0d\u7167
\nfunction az_num($str){
\nif(strtoupper($str)==”A”){return 1;}
\nif(strtoupper($str)==”B”){return 2;}
\nif(strtoupper($str)==”C”){return 3;}
\nif(strtoupper($str)==”D”){return 4;}
\nif(strtoupper($str)==”E”){return 5;}
\nif(strtoupper($str)==”F”){return 6;}
\nif(strtoupper($str)==”G”){return 7;}
\nif(strtoupper($str)==”H”){return 8;}
\nif(strtoupper($str)==”I”){return 9;}
\nif(strtoupper($str)==”J”){return 10;}
\nif(strtoupper($str)==”K”){return 11;}
\nif(strtoupper($str)==”L”){return 12;}
\nif(strtoupper($str)==”M”){return 13;}
\nif(strtoupper($str)==”N”){return 14;}
\nif(strtoupper($str)==”O”){return 15;}
\nif(strtoupper($str)==”P”){return 16;}
\nif(strtoupper($str)==”Q”){return 17;}
\nif(strtoupper($str)==”R”){return 18;}
\nif(strtoupper($str)==”S”){return 19;}
\nif(strtoupper($str)==”T”){return 20;}
\nif(strtoupper($str)==”U”){return 21;}
\nif(strtoupper($str)==”V”){return 22;}
\nif(strtoupper($str)==”W”){return 23;}
\nif(strtoupper($str)==”X”){return 24;}
\nif(strtoupper($str)==”Y”){return 25;}
\nif(strtoupper($str)==”Z”){return 26;}
\n}<\/p>\n
\/\/\u6578\u5b57\u8f49\u82f1\u6587\u5c0d\u7167
\nfunction num_az($num){
\nif($num==1){return “A”;}
\nif($num==2){return “B”;}
\nif($num==3){return “C”;}
\nif($num==4){return “D”;}
\nif($num==5){return “E”;}
\nif($num==6){return “F”;}
\nif($num==7){return “G”;}
\nif($num==8){return “H”;}
\nif($num==9){return “I”;}
\nif($num==10){return “J”;}
\nif($num==11){return “K”;}
\nif($num==12){return “L”;}
\nif($num==13){return “M”;}
\nif($num==14){return “N”;}
\nif($num==15){return “O”;}
\nif($num==16){return “P”;}
\nif($num==17){return “Q”;}
\nif($num==18){return “R”;}
\nif($num==19){return “S”;}
\nif($num==20){return “T”;}
\nif($num==21){return “U”;}
\nif($num==22){return “V”;}
\nif($num==23){return “W”;}
\nif($num==24){return “X”;}
\nif($num==25){return “Y”;}
\nif($num==0){return “Z”;}
\n}
\n?><\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u532f\u5165Excel\u7684\u6642\u5019\uff0c\u56e0\u70ba\u8b80\u53d6\u5230\u7684Col\u70ba\u82f1\u6587\u6a19\u793a\uff0c\u770b\u8d77\u4f86\u50cf\u662f26\u9032\u4f4d\uff0c\u4f46\u662f\u662fA~Z\u4f86\u8868\u793aA=1, B=2, … \u95b1\u8b80\u5168\u6587\u3008php\u63db\u7b97Excel\u7684Column\u82f1\u6587\u8207\u6578\u5b57\u8f49\u63db\u3009<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1814"}],"collection":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1814"}],"version-history":[{"count":2,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1814\/revisions"}],"predecessor-version":[{"id":1816,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/1814\/revisions\/1816"}],"wp:attachment":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}