本文实例讲述了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.     }