在phpexcel中为列添加标题时，它会隐藏第一行结果

Question

  $users = $query->result_array();
    $this->excel->getActiveSheet()->SetCellValue('A1', 'Name');

    $this->excel->getActiveSheet()->SetCellValue('B1', 'Email');
    $this->excel->getActiveSheet()->SetCellValue('C1', 'Gender');
    $this->excel->getActiveSheet()->SetCellValue('D1', 'DOB');
    $this->excel->getActiveSheet()->SetCellValue('E1', 'Class');
    $this->excel->getActiveSheet()->SetCellValue('F1', 'School Name');
    $this->excel->getActiveSheet()->SetCellValue('G1', 'City');
    $this->excel->getActiveSheet()->SetCellValue('H1', 'State');
    $this->excel->getActiveSheet()->SetCellValue('I1', 'Primary Contact');
    $this->excel->getActiveSheet()->SetCellValue('J1', 'Secondary Contact');
    $this->excel->getActiveSheet()->SetCellValue('K1', 'Teacher Contact');
    $this->excel->getActiveSheet()->fromArray($users);



    $filename = 'userlist.xls'; //save our workbook as this file name

    header('Content-Type: application/vnd.ms-excel'); //mime type

    header('Content-Disposition: attachment;filename="' . $filename . '"'); //tell browser what's the file name

    header('Cache-Control: max-age=0'); //no cache


    $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel5');


    $objWriter->save('php://output');

I'm working this code on CodeIgniter. it works fine but the only thing I am not able to fix it hides the first row of database output. how to shift database result to start from A2.

Answer 1

you may reference cell no starting on cell no

$current_cell = 2;
foreach ($cell_val as $cell) {
   $objPHPExcel->getActiveSheet()->fromArray($cell, null, 'A'.$current_cell);
   $current_cell++;
}