PHP For循环字母A-Z当超过26个字母时输出AA,AB,AC

php循环输出26个大小写英文字母

for($i=65;$i<91;$i++){
  echo strtolower(chr($i)).' ';//输出小写字母
  echo strtoupper(chr($i)).' ';//输出大写字母
}

PHP For循环字母A-Z当超过26个字母时输出AA,AB,AC

for ($i = 0; $i <= 1000; $i++) {
$y = ($i / 26);
echo $i,"=>";
if ($y >= 1) {
$y = intval($y);
echo chr($y+64);
echo chr($i-$y*26 + 65);
} else {
echo chr($i+65);
}
echo "\r\n";
}

这里就完成了,经过测试确实不错,原理就是通过php的chr() 函数从指定 ASCII 值返回字符。

具体的资料可以查看这篇文章:https://www.jb51.net/article/156073.htm

$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(18); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(14); $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(14); $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(18); $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('R')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('S')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('T')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('U')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('V')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('W')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('X')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('Y')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('Z')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('AA')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('AB')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('AC')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('AD')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('AE')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('AF')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('AG')->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension('AH')->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension('AI')->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension('AJ')->setWidth(18); $objPHPExcel->getActiveSheet()->getColumnDimension('AK')->setWidth(18); $objPHPExcel->getActiveSheet()->getStyle('A:AK')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:AK1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:AK1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle('A1:AK1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $objPHPExcel->getActiveSheet()->getStyle('A1:Q1')->getFill()->getStartColor()->setARGB('7C9BDE'); $objPHPExcel->getActiveSheet()->getStyle('R1:AE1')->getFill()->getStartColor()->setARGB('FFCCCC'); $objPHPExcel->getActiveSheet()->getStyle('AF1:AK1')->getFill()->getStartColor()->setARGB('FFE300'); $objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(30); 当数不确定,上方的表格样式改如何设置
最新发布
12-10
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值