How to fill cells dynamically in PHPExcel?

Question

phpspreadsheet

Hello
I have this problem using PHPExcel

$sheet->setCellValue("A1", 'ФИО');
    $sheet->setCellValue("B1", 'Компания');
    $sheet->setCellValue("C1", 'Тест');
    $sheet->setCellValue("D1", 'Результат');
    $sheet->setCellValue("E1", 'Балл');
    
    $itr = 0;
    foreach($report as $key){
      $sheet->setCellValue("A".($itr + 2), $key["user_name"]);
      $sheet->setCellValue("B".($itr + 2), $key["company_title"]);
      $sheet->setCellValue("C".($itr + 2), $key["test"]);
      $sheet->setCellValue("D".($itr + 2), $key["word"]);
      $sheet->setCellValue("E".($itr + 2), $key["score"]);
      $itr++;
    }

Here there are cells, that is, A1, etc., but the problem is that these very cells should be generated automatically and I don’t know what letters will be there. How to be?

Answer 1

everything seems to be simple - we add 2 counters for the data array (1 - a letter, 2 - a number), well, we do a cycle ala

for ($i = 1, $i < count($data), $i++) {
  for ($j = 1, $j < count($data[$i]), $j++) {
    eсho 'Ячейка ' . $i . 'x' . $j . ': ' . $data[$i][$j];
  }
}