How to get the array of column PHPExcel?

Good afternoon, tell me is it in PHPExcel method to retrieve all the values in the column to the array and the same with the construction project?
June 5th 19 at 21:33
2 answers
June 5th 19 at 21:35
rangeToArray
as "the construction site" - I don't know
and as with the column?) - nikita.Stracke commented on June 5th 19 at 21:38
June 5th 19 at 21:37
the issue has been resolved

$sheet = $objPHPExcel->getActiveSheet();
$array_data = array();
foreach($sheet->getRowIterator() as $row){
 $rowIndex = $row->getRowIndex ();
 $array_data[$rowIndex] = array('A'=>", 'B'=>",'C'=>",'D'=>");

 $cell = $sheet->getCell('A' . $rowIndex);
 $array_data[$rowIndex]['A'] = $cell->getCalculatedValue();
 $cell = $sheet->getCell('B' . $rowIndex);
 $array_data[$rowIndex]['B'] = $cell->getCalculatedValue();
 $cell = $sheet->getCell('C' . $rowIndex);
 $array_data[$rowIndex]['C'] = $cell->getCalculatedValue();
 $cell = $sheet->getCell('D' . $rowIndex);
 $array_data[$rowIndex]['D'] = $cell->getCalculatedValue();
}

Find more questions by tags PHPPhpSpreadsheet