当前位置：首页 > 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.  
  77. $objExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10); 
  78.  
  79. $objExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10); 
  80.  
  81. $objExcel->getActiveSheet()->getColumnDimension('C')->setWidth(70); 
  82.  
  83. $objExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); 
  84.  
  85. $objExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15); 
  86.  
  87. $objExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&BPersonal cash register&RPrinted on &D'); 
  88.  
  89. $objExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B'.$objExcel->getProperties()->getTitle() .'&RPage &P of &N'); 
  90.  
  91. // 设置页方向和规模 
  92.  
  93. $objExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT); 
  94.  
  95. $objExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); 
  96.  
  97. $objExcel->setActiveSheetIndex(0); 
  98.  
  99. $timestamp= time(); 
  100.  
  101. if($ex=='2007') {//导出excel2007文档 
  102.  
  103.   header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); 
  104.  
  105.   header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xlsx"'); 
  106.  
  107.   header('Cache-Control: max-age=0'); 
  108.  
  109.   $objWriter= PHPExcel_IOFactory::createWriter($objExcel,'Excel2007'); 
  110.  
  111.   $objWriter->save('php://output'); 
  112.  
  113.   exit; 
  114.  
  115. }else{//导出excel2003文档 
  116.  
  117.   header('Content-Type: application/vnd.ms-excel'); 
  118.  
  119.   header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xls"'); 
  120.  
  121.   header('Cache-Control: max-age=0'); 
  122.  
  123.   $objWriter= PHPExcel_IOFactory::createWriter($objExcel,'Excel5'); 
  124.  
  125.   $objWriter->save('php://output'); 
  126.  
  127.   exit; 
  128.  
  129. } 
  130.  
  131.     require_once'common/excel/PHPExcel.php'; 
  132.     require_once'common/excel/phpExcel/Writer/Excel2007.php'; 
  133.     require_once'common/excel/phpExcel/Writer/Excel5.php'; 
  134.     include_once'common/excel/phpExcel/IOFactory.php'; 
  135.     $objExcel=newPHPExcel(); 
  136.     //设置属性 (这段代码无关紧要，其中的内容可以替换为你需要的) 
  137.     $objExcel->getProperties()->setCreator("andy"); 
  138.     $objExcel->getProperties()->setLastModifiedBy("andy"); 
  139.     $objExcel->getProperties()->setTitle("Office 2003 XLS Test Document"); 
  140.     $objExcel->getProperties()->setSubject("Office 2003 XLS Test Document"); 
  141.     $objExcel->getProperties()->setDescription("Test document for Office 2003 XLS, generated using PHP classes."); 
  142.     $objExcel->getProperties()->setKeywords("office 2003 openxml php"); 
  143.     $objExcel->getProperties()->setCategory("Test result file"); 
  144.     $objExcel->setActiveSheetIndex(0); 
  145.     $i=0; 
  146.     //表头 
  147.     $k1="编号"; 
  148.     $k2="推广代码"; 
  149.     $k3="访问来源"; 
  150.     $k4="IP"; 
  151.     $k5="访问时间"; 
  152.     $objExcel->getActiveSheet()->setCellValue('a1',"$k1"); 
  153.     $objExcel->getActiveSheet()->setCellValue('b1',"$k2"); 
  154.     $objExcel->getActiveSheet()->setCellValue('c1',"$k3"); 
  155.     $objExcel->getActiveSheet()->setCellValue('d1',"$k4"); 
  156.     $objExcel->getActiveSheet()->setCellValue('e1',"$k5"); 
  157.     //debug($links_list); 
  158.     foreach($links_listas$k=>$v) { 
  159.       $u1=$i+2; 
  160.       /*----------写入内容-------------*/ 
  161.       $objExcel->getActiveSheet()->setCellValue('a'.$u1,$v["id"]); 
  162.       $objExcel->getActiveSheet()->setCellValue('b'.$u1,$v["num"]); 
  163.       $objExcel->getActiveSheet()->setCellValue('c'.$u1,$v["referer"]); 
  164.       $objExcel->getActiveSheet()->setCellValue('d'.$u1,$v["ip"]); 
  165.       $objExcel->getActiveSheet()->setCellValue('e'.$u1,$v["dateline"]); 
  166.       $i++; 
  167.     } 
  168.     // 高置列的宽度 
  169.     $objExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10); 
  170.     $objExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10); 
  171.     $objExcel->getActiveSheet()->getColumnDimension('C')->setWidth(70); 
  172.     $objExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15); 
  173.     $objExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15); 
  174.     $objExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&BPersonal cash register&RPrinted on &D'); 
  175.     $objExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B'.$objExcel->getProperties()->getTitle() .'&RPage &P of &N'); 
  176.     // 设置页方向和规模 
  177.     $objExcel->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT); 
  178.     $objExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4); 
  179.     $objExcel->setActiveSheetIndex(0); 
  180.     $timestamp= time(); 
  181.     if($ex=='2007') {//导出excel2007文档 
  182.       header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); 
  183.       header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xlsx"'); 
  184.       header('Cache-Control: max-age=0'); 
  185.       $objWriter= PHPExcel_IOFactory::createWriter($objExcel,'Excel2007'); 
  186.       $objWriter->save('php://output'); 
  187.       exit; 
  188.     }else{//导出excel2003文档 
  189.       header('Content-Type: application/vnd.ms-excel'); 
  190.       header('Content-Disposition: attachment;filename="links_out'.$timestamp.'.xls"'); 
  191.       header('Cache-Control: max-age=0'); 
  192.       $objWriter= PHPExcel_IOFactory::createWriter($objExcel,'Excel5'); 
  193.       $objWriter->save('php://output'); 
  194.       exit; 
  195.     } 

Tags: 实例 代码 文档

分享到：

相关文章

推荐文章

热门文章

最新评论文章