[FIXED] How to set looping number in PHPExcel with Codeigniter

Issue

Image

how to loop number in phpexcel?

i use codeigniter.

$rs = $this->db->get('inventory_barang');
$exceldata="";
foreach ($rs->result_array() as $row){
$exceldata[] = $row;
}

//How should i do for looping 
$this->excel->getActiveSheet()->fromArray('I want number to be looping for column A from A4', null, 'A4');

// read data to active sheet
$this->excel->getActiveSheet()->fromArray($exceldata, null, 'B4');

Solution

You can add number to your array:

$rs = $this->db->get('inventory_barang');
$exceldata = [];
foreach ($rs->result_array() as $key=>$row){
    $exceldata[] = array_merge([$key], $row);
}
$this->excel->getActiveSheet()->fromArray($exceldata, null, 'A4');

Answered By - weigreen

Answer Checked By - Candace Johnson (PHPFixing Volunteer)