dongnaoben4456
2015-11-19 09:14 阅读 40
已采纳

递增循环到excel单元格水平PHP

I am working in a reporting module using Laravel 5 and http://www.maatwebsite.nl/laravel-excel and my question is how to I populate a data in excel horizontally? Because, vertically it's pretty easy let's say I want to populate vertically is cell A1 onwards so I can go with

for($x=1;$x=<5000;$x++)
{
  $sheet->cell('A'.$x, 'Some Value');
}

But what about horizontally? Let's say I will begin in A1 onwards on a loop? How do I that? Coz excel has the formatting of cell location like AA, BBB, ABC etc.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    doushi8186 doushi8186 2015-11-19 09:18

    Use PHPs Perl-style character incrementing

    for($x='A'; $x != 'IW'; $x++)
    {
      $sheet->cell($x . '1', 'Some Value');
    }
    

    Note that you can't use a < comparison for the termination, because the comparison will be alphabetic and AA is alphabetically less than B; so you use a != comparison instead with a column address one higher than the last you want to access.... the above will finish after cell IV

    点赞 评论 复制链接分享

相关推荐