分享最新版本PHPEXCEL导出excel简单实例

追影

1. function test_excel(){
   
2. import ('@.ORG.PHPExcel' );//引入PHPExcel类
   
3. $objPHPExcel = new PHPExcel();
   
4. $cellName = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK','AL','AM','AN','AO','AP','AQ','AR','AS','AT','AU','AV','AW','AX','AY','AZ');
   
5. $title_array = array('姓名','性别');
   
6. $data_array = array(
   
7. array('张三','男'),
   
8. array('李四','女'),
   
9. array('王五','男')
   
10. );
    
11. $cellNum = count($title_array);
    
12. $dataNum = count($data_array);
    
13. //输出表头
    
14. $objPHPExcel->setActiveSheetIndex(0);
    
15. for($i=0;$i<$cellNum;$i++){
    
16. $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i].'1', $title_array[$i]);
    
17. }
    
18. //输出内容
    
19. for($i=0;$i<$dataNum;$i++){
    
20.           for($j=0;$j<$cellNum;$j++){
    
21.             $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$j].($i+2), $data_array[$i][$j]);
    
22.           }            
    
23.         }  
    
24. // Rename worksheet
    
25. $objPHPExcel->getActiveSheet()->setTitle('会员表');
    
26. // Set active sheet index to the first sheet, so Excel opens this as the first sheet
    
27. $objPHPExcel->setActiveSheetIndex(0);
    
28. // Redirect output to a client’s web browser (Excel5)
    
29. header('Content-Type: application/vnd.ms-excel');
    
30. header('Content-Disposition: attachment;filename="01simple.xls"');
    
31. header('Cache-Control: max-age=0');
    
32. // If you're serving to IE 9, then the following may be needed
    
33. header('Cache-Control: max-age=1');
    
34. 
    
35. // If you're serving to IE over SSL, then the following may be needed
    
36. header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
    
37. header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
    
38. header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
    
39. header ('Pragma: public'); // HTTP/1.0
    
40. 
    
41. $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    
42. $objWriter->save('php://output');
    
43. }

复制代码