Welcome Guest, Not a member yet? Register   Sign In
PHP export to Excel
#1

[eluser]Unknown[/eluser]
I was written code same below but given error . can any body help me.

$this->load->plugin('PHPExcel');
$this->load->plugin('PHPExcel/IOFactory');
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setTitle("export")->setDescription("none");

$objPHPExcel->setActiveSheetIndex(0);

// Field names in the first row
$fields = $query->list_fields();
$col = 0;
for($i=0;$i<count($fields);$i++)
{
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field[$i]);
$col++;
}
/*foreach ($fields as $field)
{
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, 1, $field);
$col++;
}*/

// Fetching the table data
$row = 2;
foreach($query->result_array() as $data)
{
$col = 0;
foreach ($fields as $field)
{
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $data->$field);
$col++;
}

$row++;
}

$objPHPExcel->setActiveSheetIndex(0);

$objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5');

// Sending headers to force the user to download the file
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Products_'.date('dMy').'.xls"');
header('Cache-Control: max-age=0');

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




Theme © iAndrew 2016 - Forum software by © MyBB