PHPEXCEL导出excel在kohana中显示机器码如何清除？

Question

I have tried this code as like

require_once dirname(__FILE__) . '/../../vendor/PHPExcel/Classes/PHPExcel.php';

    $objPHPExcel = new PHPExcel();
    $objPHPExcel->setActiveSheetIndex()->setCellValue('A1', 'Hello world!');
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

    $this->response->body( $objWriter->save('php://output'));
    $this->response->send_file(TRUE, '01simple.xls');
    exit;

and error getting like as following image

Answer 1

Could you please try this...

require_once dirname(__FILE__) . '/../../vendor/PHPExcel/Classes/PHPExcel.php';
$phpExcel = new PHPExcel();
$phpExcel->getActiveSheet()->setTitle("Title of my excel");
$phpExcel->setActiveSheetIndex(0);
$phpExcel->getActiveSheet()->SetCellValue('A1', 'Hello');
$filename = "file_name";
ob_clean();
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $filename . '.xlsx"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($phpExcel, 'Excel2007');
ob_end_clean();
$objWriter->save('php://output');