PHP two ways to export excel

What you need: jquery library, Phpexcel plugin, page export Excel effect test file Explode.php,excel Export function implement file exp.php and explode_excel.php, file related content under this article:

explode.php: Test page content: After you visit this page, click Explode1 and Explode2 Excel, which can export two different effects, with the following code:

 
  
 <title></title>
 
 
  
 
  
  
 
   
 
    
Date
 
    
CSAT Score
 
    
Grand Total
 
    
CSAT
 
   
 
   
 
    
08/01/11
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0%
 
   
 
   
 
    
08/01/11
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0%
 
   
 
   
 
    
08/01/11
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0%
 
   
 
  

 
 

First, use the Phpexcel plugin to export the contents of Excel, the exp.php file:

 GetProperties ()->setcreator ("Li Han Regiment"), $objPHPExcel->getproperties ()->setlastmodifiedby ("Li Han Regiment"); Objphpexcel->getproperties ()->settitle ("Office XLSX Test Document"), $objPHPExcel->getproperties ()- >setsubject ("Office XLSX Test Document"), $objPHPExcel->getproperties ()->setdescription ("Test document For Office the XLSX, generated using PHP classes. "); Add some data$objphpexcel->setactivesheetindex (0), $objPHPExcel->getactivesheet ()->setcellvalue (' A1 ', ' Date ');//merged cell: $objPHPExcel->getactivesheet ()->mergecells (' b1:f1 '); $objPHPExcel->getactivesheet ()- >setcellvalue (' B1 ', ' CSAT score '); $objPHPExcel->getactivesheet ()->setcellvalue (' G1 ', ' Grand total '); $ Objphpexcel->getactivesheet ()->setcellvalue (' H1 ', ' CSAT '); $objPHPExcel->getactivesheet () Setcellvalue (' A2 ', ' 08/01/11 '); $objPHPExcel->getactivesheet ()->setcellvalue (' B2 ', ' 0 '); $objPHPExcel Getactivesheet ()->setcellvalue (' C2 ', ' 0 '); $objPHPExcel->getactivesheET ()->setcellvalue (' D2 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' E2 ', ' 0 '); $objPHPExcel Getactivesheet ()->setcellvalue (' F2 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' G2 ', ' 0 '); $ Objphpexcel->getactivesheet ()->setcellvalue (' H2 ', ' 0% '); $objPHPExcel->getactivesheet () Setcellvalue (' A3 ', ' 08/01/11 '); $objPHPExcel->getactivesheet ()->setcellvalue (' B3 ', ' 0 '); $objPHPExcel Getactivesheet ()->setcellvalue (' C3 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' D3 ', ' 0 '); $ Objphpexcel->getactivesheet ()->setcellvalue (' E3 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' F3 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' G3 ', ' 0 '); $objPHPExcel->getactivesheet () Setcellvalue (' H3 ', ' 0% '); $objPHPExcel->getactivesheet ()->setcellvalue (' A4 ', ' 08/01/11 '); $objPHPExcel Getactivesheet ()->setcellvalue (' B4 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' C4 ', ' 0 '); $ Objphpexcel->getaCtivesheet ()->setcellvalue (' D4 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' E4 ', ' 0 '); $ Objphpexcel->getactivesheet ()->setcellvalue (' F4 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' G4 ', ' 0 '); $objPHPExcel->getactivesheet ()->setcellvalue (' H4 ', ' 0% ');    Rename Sheet$objphpexcel->getactivesheet ()->settitle (' Csat ');   Save Excel file//$objWriter = new phpexcel_writer_excel2007 ($objPHPExcel); $objWriter = new Phpexcel_writer_excel5 ($objPHPExcel); $objWriter->save (Str_replace ('. php ', '. xls ', __file__)); Header ("Pragma:public"); Header ("expires:0"); Header ("cache-control:must-revalidate,post-check=0,pre-check=0"); Header ("Content-type:application/force-download"); Header ("Content-type:application/vnd.ms-execl"); Header ("Content-type:application/octet-stream"); Header ("Content-type:application/download"); Header ("Content-disposition:attachment;filename=csat.xls"); Header ("Content-transfer-encoding:binary"); $objWriter->save ("phP://output ");? >

Second, directly using the header to export HTML, specify the style of Excel, that is, the contents of explode_excel.php, as follows:

 
 
  
 <title>Untitled Document</title> 
 
 
  
 
  
  
 
   
 
    
Date
 
    
CSAT Score
 
    
Grand Total
 
    
CSAT
 
   
 
   
 
    
08/01/11
 
    
0
 
    
0
 
    
Test content!!
 
    
0
 
    
0
 
    
0
 
    
0%
 
   
 
   
 
    
08/01/11
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0%
 
   
 
   
 
    
08/01/11
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0
 
    
0%
 
   
 
  

 
 
";? >

