当前位置:首页 > PHP教程 > php应用 > 列表

PHPExcel导出2003和2007的excel文档功能的实例代码

发布:smiling 来源: PHP粉丝网  添加日期:2018-06-19 11:05:19 浏览: 评论:0 

本文实例讲述了PHPExcel导出2003和2007的excel文档功能,分享给大家供大家参考,具体如下.

  1. require_once'common/excel/PHPExcel.php'
  2.  
  3. require_once'common/excel/phpExcel/Writer/Excel2007.php'
  4.  
  5. require_once'common/excel/phpExcel/Writer/Excel5.php'
  6.  
  7. include_once'common/excel/phpExcel/IOFactory.php'
  8.  
  9. $objExcel=newPHPExcel(); 
  10.  
  11. //设置属性 (这段代码无关紧要,其中的内容可以替换为你需要的) 
  12. //phpfensi.com 
  13. $objExcel->getProperties()->setCreator("andy"); 
  14.  
  15. $objExcel->getProperties()->setLastModifiedBy("andy"); 
  16.  
  17. $objExcel->getProperties()->setTitle("Office 2003 XLS Test Document"); 
  18.  
  19. $objExcel->getProperties()->setSubject("Office 2003 XLS Test Document"); 
  20.  
  21. $objExcel->getProperties()->setDescription("Test document for Office 2003 XLS, generated using PHP classes."); 
  22.  
  23. $objExcel->getProperties()->setKeywords("office 2003 openxml php"); 
  24.  
  25. $objExcel->getProperties()->setCategory("Test result file"); 
  26.  
  27. $objExcel->setActiveSheetIndex(0); 
  28.  
  29. $i=0; 
  30.  
  31. //表头 
  32.  
  33. $k1="编号"
  34.  
  35. $k2="推广代码"
  36.  
  37. $k3="访问来源"
  38.  
  39. $k4="IP"
  40.  
  41. $k5="访问时间"
  42.  
  43. $objExcel->getActiveSheet()->setCellValue('a1',"$k1"); 
  44.  
  45. $objExcel->getActiveSheet()->setCellValue('b1',"$k2"); 
  46.  
  47. $objExcel->getActiveSheet()->setCellValue('c1',"$k3"); 
  48.  
  49. $objExcel->getActiveSheet()->setCellValue('d1',"$k4"); 
  50.  
  51. $objExcel->getActiveSheet()->setCellValue('e1',"$k5"); 
  52.  
  53. //debug($links_list); 
  54.  
  55. foreach($links_listas$k=>$v) { 
  56.  
  57.   $u1=$i+2; 
  58.  
  59.   /*----------写入内容-------------*/ 
  60.  
  61.   $objExcel->getActiveSheet()->setCellValue('a'.$u1,$v["id"]); 
  62.  
  63.   $objExcel->getActiveSheet()->setCellValue('b'.$u1,$v["num"]); 
  64.  
  65.   $objExcel->getActiveSheet()->setCellValue('c'.$u1,$v["referer"]); 
  66.  
  67.   $objExcel->getActiveSheet()->setCellValue('d'.$u1,$v["ip"]); 
  68.  
  69.   $objExcel->getActiveSheet()->setCellValue('e'.$u1,$v["dateline"]); 
  70.  
  71.   $i++; 
  72.  
  73.  
  74. // 高置列的宽度 
  75.  
  76. $objExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10); 
  77.  
  78. $objExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10); 
  79.  
  80. $objExcel->getActiveSheet()->getColumnDimension('C')->setWidth(70); 
  81.  
  82. $objExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); 
  83.  
  84. $objExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15); 
  85.  
  86. $objExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&BPersonal cash register&RPrinted on &D'); 
  87.  
  88. $objExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B'.$objExcel->getProperties()->getTitle() .'&RPage &P of &N'); 
  89.  
  90. // 设置页方向和规模 
  91.  
  92. $objExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT); 
  93.  
  94. $objExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); 
  95.  
  96. $objExcel->setActiveSheetIndex(0); 
  97.  
  98. $timestamp= time(); 
  99.  
  100. if($ex=='2007') {//导出excel2007文档 
  101.  
  102.   header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); 
  103.  
  104.   header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xlsx"'); 
  105.  
  106.   header('Cache-Control: max-age=0'); 
  107.  
  108.   $objWriter= PHPExcel_IOFactory::createWriter($objExcel,'Excel2007'); 
  109.  
  110.   $objWriter->save('php://output'); 
  111.  
  112.   exit
  113.  
  114. }else{//导出excel2003文档 
  115.  
  116.   header('Content-Type: application/vnd.ms-excel'); 
  117.  
  118.   header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xls"'); 
  119.  
  120.   header('Cache-Control: max-age=0'); 
  121.  
  122.   $objWriter= PHPExcel_IOFactory::createWriter($objExcel,'Excel5'); 
  123.  
  124.   $objWriter->save('php://output'); 
  125.  
  126.   exit
  127.  
  128.  
  129.     require_once'common/excel/PHPExcel.php'
  130.     require_once'common/excel/phpExcel/Writer/Excel2007.php'
  131.     require_once'common/excel/phpExcel/Writer/Excel5.php'
  132.     include_once'common/excel/phpExcel/IOFactory.php'
  133.     $objExcel=newPHPExcel(); 
  134.     //设置属性 (这段代码无关紧要,其中的内容可以替换为你需要的) 
  135.     $objExcel->getProperties()->setCreator("andy"); 
  136.     $objExcel->getProperties()->setLastModifiedBy("andy"); 
  137.     $objExcel->getProperties()->setTitle("Office 2003 XLS Test Document"); 
  138.     $objExcel->getProperties()->setSubject("Office 2003 XLS Test Document"); 
  139.     $objExcel->getProperties()->setDescription("Test document for Office 2003 XLS, generated using PHP classes."); 
  140.     $objExcel->getProperties()->setKeywords("office 2003 openxml php"); 
  141.     $objExcel->getProperties()->setCategory("Test result file"); 
  142.     $objExcel->setActiveSheetIndex(0); 
  143.     $i=0; 
  144.     //表头 
  145.     $k1="编号"
  146.     $k2="推广代码"
  147.     $k3="访问来源"
  148.     $k4="IP"
  149.     $k5="访问时间"
  150.     $objExcel->getActiveSheet()->setCellValue('a1',"$k1"); 
  151.     $objExcel->getActiveSheet()->setCellValue('b1',"$k2"); 
  152.     $objExcel->getActiveSheet()->setCellValue('c1',"$k3"); 
  153.     $objExcel->getActiveSheet()->setCellValue('d1',"$k4"); 
  154.     $objExcel->getActiveSheet()->setCellValue('e1',"$k5"); 
  155.     //debug($links_list); 
  156.     foreach($links_listas$k=>$v) { 
  157.       $u1=$i+2; 
  158.       /*----------写入内容-------------*/ 
  159.       $objExcel->getActiveSheet()->setCellValue('a'.$u1,$v["id"]); 
  160.       $objExcel->getActiveSheet()->setCellValue('b'.$u1,$v["num"]); 
  161.       $objExcel->getActiveSheet()->setCellValue('c'.$u1,$v["referer"]); 
  162.       $objExcel->getActiveSheet()->setCellValue('d'.$u1,$v["ip"]); 
  163.       $objExcel->getActiveSheet()->setCellValue('e'.$u1,$v["dateline"]); 
  164.       $i++; 
  165.     } 
  166.     // 高置列的宽度 
  167.     $objExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10); 
  168.     $objExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10); 
  169.     $objExcel->getActiveSheet()->getColumnDimension('C')->setWidth(70); 
  170.     $objExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); 
  171.     $objExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15); 
  172.     $objExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&BPersonal cash register&RPrinted on &D'); 
  173.     $objExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B'.$objExcel->getProperties()->getTitle() .'&RPage &P of &N'); 
  174.     // 设置页方向和规模 
  175.     $objExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT); 
  176.     $objExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); 
  177.     $objExcel->setActiveSheetIndex(0); 
  178.     $timestamp= time(); 
  179.     if($ex=='2007') {//导出excel2007文档 
  180.       header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); 
  181.       header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xlsx"'); 
  182.       header('Cache-Control: max-age=0'); 
  183.       $objWriter= PHPExcel_IOFactory::createWriter($objExcel,'Excel2007'); 
  184.       $objWriter->save('php://output'); 
  185.       exit
  186.     }else{//导出excel2003文档 
  187.       header('Content-Type: application/vnd.ms-excel'); 
  188.       header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xls"'); 
  189.       header('Cache-Control: max-age=0'); 
  190.       $objWriter= PHPExcel_IOFactory::createWriter($objExcel,'Excel5'); 
  191.       $objWriter->save('php://output'); 
  192.       exit
  193.     } 

Tags: 实例 代码 文档

分享到: