记录下用数字对应EXECEL表头的字母

最新推荐文章于 2023-09-07 15:22:12 发布

鲁拉里

最新推荐文章于 2023-09-07 15:22:12 发布

阅读量292

点赞数

CC 4.0 BY-SA版权

分类专栏：笔记文章标签： php

本文链接：https://blog.youkuaiyun.com/fswy2017/article/details/64437748

笔记专栏收录该内容

26 篇文章

订阅专栏

记录下用数字对应EXECEL表头的字母

$base_letter = array('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');

$total = 100;

$maps = array();

for ($i=0;$i<$total;++$i){
    $letter_string = "";
    $temp = $i;
    while ($temp>25){
        $letter_string .= $base_letter[$temp/26-1];
        $temp %= 26;
    }
    $letter_string .= $base_letter[$temp];
    $maps[$i] = $letter_string;
}