PHP Export Excel File

out_excel.php

<?php
Error_reporting (E_all);
Date_default_timezone_set (' Asia/shanghai ');
Require_once ' phpexcel/phpexcel.php ';
$data =array (
0=>array (
' ID ' =>1001,
' username ' = ' Zhang Fei ',
' Password ' = ' 123456 ',
' Address ', ' Three Kingdoms ' Gao 250 lane, Room 101 '
),
1=>array (
' ID ' =>1002,
' Username ' = ' Guan Yu ',
' Password ' = ' 123456 ',
' Address ' = ' Three Kingdoms when Huaguoshan '
)
);
$objPHPExcel =new phpexcel ();
$objPHPExcel->getproperties ()->setcreator (' http://www.jb51.net ')
->setlastmodifiedby (' http://www.jb51.net ')
->settitle (' Office of XLSX Document ')
->setsubject (' Office of XLSX Document ')
->setdescription (' Document for Office ' XLSX, generated using PHP classes. ')
->setkeywords (' Office openxml php ')
->setcategory (' Result file ');
$objPHPExcel->setactivesheetindex (0)
->setcellvalue (' A1 ', ' ID ')
->setcellvalue (' B1 ', ' username ')
->setcellvalue (' C1 ', ' password ')
->setcellvalue (' D1 ', ' address ');

$i = 2;
foreach ($data as $k = = $v) {
$objPHPExcel->setactivesheetindex (0)
->setcellvalue (' A '. $i, $v [' ID '])
->setcellvalue (' B '. $i, $v [' username '])
->setcellvalue (' C '. $i, $v [' Password '])
->setcellvalue (' D '. $i, $v [' address ']);
$i + +;
}
$objPHPExcel->getactivesheet ()->settitle (' Third Grade 2 class ');
$objPHPExcel->setactivesheetindex (0);
$filename =urlencode (' Student Information tab '). ' _ '. Date (' Y-m-dhis ');

/** Generate xlsx file */
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 ($objPHPExcel, ' Excel2007 ');

/*
* Generate XLS file
Header (' Content-type:application/vnd.ms-excel ');
Header (' Content-disposition:attachment;filename= '. $filename. '. XLS "');
Header (' cache-control:max-age=0 ');
$objWriter = Phpexcel_iofactory::createwriter ($objPHPExcel, ' Excel5 ');
*/
$objWriter->save (' php://output ');
Exit

PHP Export Excel File