PHP export Excel PHP using Phpexcel export Excel file

Load Phpexcel class Require './phpexcel/phpexcel.php '; Create an instance of an Excel object $objPHPExcel = new Phpexcel (); Set document basic Properties $objProps = $objPHPExcel->getproperties (); $objProps->setcreator ("Lao Mao"); $objProps->setlastmodifiedby ("Lao Mao"); $objProps->settitle ("Office XLS Test Document"); $objProps->setsubject ("Office XLS Test Document, Demo"); $objProps->setdescription ("Test document, generated by Phpexcel."); $objProps->setkeywords ("Office Excel Phpexcel"); $objProps->setcategory ("Test"); Sets the current sheet index for subsequent content operations. It is generally only necessary to display a call when multiple sheet are used. By default, Phpexcel automatically creates the first sheet to be set sheetindex=0 $objPHPExcel->setactivesheetindex (0); Sets the name of the currently active sheet $objActSheet = $objPHPExcel->getactivesheet (); $objActSheet->settitle (' Test sheet '); Set cell contents The data here can be read from the database and then processed in a loop by bbs.it-home.org $objPHPExcel->getactivesheet ()->setcellvalue (' A1 ', ' A1 '); $objPHPExcel->getactivesheet ()->setcellvalue (' A2 ', ' A2 '); $objPHPExcel->getactivesheet ()->setcellvalue (' A3 ', ' A3 '); $objPHPExcel->getactivesheet ()->setcellvalue (' A4 ', ' A4 '); $objPHPExcel->getactivesheet ()->setcellvalue (' A5 ', ' A5 '); $objPHPExcel->getactivesheet ()->setcellvalue (' B1 ', ' B1 '); $objPHPExcel->getactivesheet ()->setcellvalue (' B2 ', ' B2 '); $objPHPExcel->getactivesheet ()->setcellvalue (' B3 ', ' B3 '); $objPHPExcel->getactivesheet ()->setcellvalue (' B4 ', ' b4 '); $objPHPExcel->getactivesheet ()->setcellvalue (' B5 ', ' B5 '); $objPHPExcel->getactivesheet ()->setcellvalue (' C1 ', ' C1 '); $objPHPExcel->getactivesheet ()->setcellvalue (' C2 ', ' C2 '); $objPHPExcel->getactivesheet ()->setcellvalue (' C3 ', ' C3 '); $objPHPExcel->getactivesheet ()->setcellvalue (' C4 ', ' C4 '); $objPHPExcel->getactivesheet ()->setcellvalue (' C5 ', ' C5 '); Output document $objWriter = new Phpexcel_writer_excel5 ($objPHPExcel); Headers header information is set and output to browser Header (' Content-type:application/vnd.ms-excel '); Header ("content-disposition:attachment; Filename=demo.xls "); Header (' cache-control:max-age=0 '); $objWriter->save (' php://output '); Save to a location $objWriter->save (DirName (__file__). '/demo.xls '); Copy Code

