CODEWITHSUNDEEP
phpexcellaravelphpexcel
jackhammer013
jackhammer013

Reputation: 2297

Increment Loop to a excel cells horizontally 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.

Upvotes: 1

Views: 1881

Answers (1)

Mark Baker
Mark Baker

Reputation: 212402

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

Upvotes: 4

Related Questions