Insert keys in a new array provided by another array

Question

I have the following loop:

for($column = 'A'; $column != $lastColumn; $column++) {
          for ($row = 2; $row <= 6; $row++) {
              $cell[] = $objWorksheet->getCell($column.$row)->getFormattedValue();
              if($column == 'A') {
                $arrayTeste = array('A' => $cell);
              } else {
                $arrayTeste = array('B' => $cell);
              }
          }
      }

What I want is: I want to make a new array with key 'A' using the values in 'cell' array. Because in another part of my code I need to echo just the values inside 'A' key. Like when you echo from a DB index. Example: echo $array['A']. Also in this second part, I'll need a foreach to print all the array, right?

that's not going to work. you keep overwriting arrayTeste on every loop iteration, and will end up with only the LAST value when both loops exit. — Marc B
– Marc B, Commented Jun 13, 2016 at 20:19
Why don't you just use the rangeToArray() method that's already buit into PHPExcel? — Mark Baker
– Mark Baker, Commented Jun 13, 2016 at 20:42
Thank you all for the tips. With the reply of Felippe I was able to do the work. — Rodrigo BRF
– Rodrigo BRF, Commented Jun 14, 2016 at 11:38

Kenny Grage · Accepted Answer · 2016-06-13 20:28:25Z

2

The problem with your current code is that you are going to be overwriting $arrayTeste each time you go through the loop. This can be solved with a multidimensional array as follows:

if($column == 'A') {
    $arrayTeste[$column][$row] = array('A' => $cell);
} else {
    $arrayTeste[$column][$row] = array('B' => $cell);
}

answered Jun 13, 2016 at 20:28

Kenny Grage

1,1249 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Felippe Duarte · Accepted Answer · 2016-06-13 20:30:09Z

1

Just put your data inside an array, indexed by your column:

$cell = [];
for($column = 'A'; $column != $lastColumn; $column++) {
    for ($row = 2; $row <= 6; $row++) {
        $cell[$column][] = $objWorksheet->getCell($column.$row)->getFormattedValue();
    }
}

Output will be something like:

['A'] =>
   [0] => 'cella1',
   [1] => 'cella2',
['B'] =>
   [0] => 'cellb1',
   [1] => 'cellb2',
 ...

answered Jun 13, 2016 at 20:30

Felippe Duarte

15.2k2 gold badges27 silver badges29 bronze badges

Collectives™ on Stack Overflow

Insert keys in a new array provided by another array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related