Phpexcel Exporting instances of Excel documents 2003 and 2007

2. require_once ' common/excel/phpexcel.php ';
4. require_once ' common/excel/phpexcel/writer/excel2007.php ';
6. require_once ' common/excel/phpexcel/writer/excel5.php ';
8. Include_once ' common/excel/phpexcel/iofactory.php ';
12. $objExcel = new Phpexcel ();
14. Set properties (This code doesn't matter, the content can be replaced with what you need)
16. $objExcel->getproperties ()->setcreator ("Andy");
18. $objExcel->getproperties ()->setlastmodifiedby ("Andy");
20. $objExcel->getproperties ()->settitle ("Office 2003 XLS Test Document");
22. $objExcel->getproperties ()->setsubject ("Office 2003 XLS Test Document");
24. $objExcel->getproperties ()->setdescription ("Test document for Office 2003 XLS, generated using PHP classes.");
26. $objExcel->getproperties ()->setkeywords ("Office 2003 OPENXML PHP");
28. $objExcel->getproperties ()->setcategory ("Test result file");
30. $objExcel->setactivesheetindex (0);
34. $i = 0;
36. Table header
38. $k 1="number";
40. $k 2="Promotion code";
42. $k 3="Access source";
44. $k 4="IP";
46. $k 5="Access Time";
50. $objExcel->getactivesheet ()->setcellvalue (' A1 ', "$k 1");
52. $objExcel->getactivesheet ()->setcellvalue (' B1 ', "$k 2");
54. $objExcel->getactivesheet ()->setcellvalue (' C1 ', "$k 3");
56. $objExcel->getactivesheet ()->setcellvalue (' D1 ', "$k 4");
58. $objExcel->getactivesheet ()->setcellvalue (' E1 ', "$k 5");
60. Debug ($links _list);
62. foreach ($links _list as $k = +$v) {
64. $u 1=$i +2;
66. / *----------Write content-------------* /
68. $objExcel->getactivesheet ()->setcellvalue (' a '.   $u 1, $v ["id"]);
70. $objExcel->getactivesheet ()->setcellvalue (' B ').   $u 1, $v ["num"]);
72. $objExcel->getactivesheet ()->setcellvalue (' C ').   $u 1, $v ["Referer"]);
74. $objExcel->getactivesheet ()->setcellvalue (' d '.   $u 1, $v ["IP"]);
76. $objExcel->getactivesheet ()->setcellvalue (' e ').   $u 1, $v ["Dateline"]);
78. $i + +;
80. }
84. Width of the high column
86. $objExcel->getactivesheet ()->getcolumndimension (' A ')->setwidth (10);
88. $objExcel->getactivesheet ()->getcolumndimension (' B ')->setwidth (10);
90. $objExcel->getactivesheet ()->getcolumndimension (' C ')->setwidth (70);
92. $objExcel->getactivesheet ()->getcolumndimension (' D ')->setwidth (15);
94. $objExcel->getactivesheet ()->getcolumndimension (' E ')->setwidth (15);
98. $objExcel->getactivesheet ()->getheaderfooter ()->setoddheader (' &l&bpersonal cash register  &rprinted on &d ');
100. $objExcel->getactivesheet ()->getheaderfooter ()->setoddfooter (' &l&b '. $objExcel->getproperties ()->gettitle ().  ' &rpage &p of &n ');
104. Set page orientation and size
106. $objExcel->getactivesheet ()->getpagesetup ()->setorientation (phpexcel_worksheet_pagesetup::orientation _portrait);
108. $objExcel->getactivesheet ()->getpagesetup ()->setpapersize (phpexcel_worksheet_pagesetup::P apersize_a4) ;
110. $objExcel->setactivesheetindex (0);
112. $timestamp = time ();
114. if ($ex = = ') { //export excel2007 document
116. Header (' Content-type:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet ');
118. Header (' content-disposition:attachment;filename= ' links_out '. $timestamp.  '. xlsx ');
120. Header (' cache-control:max-age=0 ');
122. $objWriter = Phpexcel_iofactory::createwriter ($objExcel, ' Excel2007 ');
124. $objWriter->save (' php://output ');
126. exit;
128. } else { //export excel2003 document
130. Header (' Content-type:application/vnd.ms-excel ');
132. Header (' content-disposition:attachment;filename= ' links_out '. $timestamp.  ' . xls ');
134. Header (' cache-control:max-age=0 ');
136. $objWriter = Phpexcel_iofactory::createwriter ($objExcel, ' Excel5 ');
138. $objWriter->save (' php://output ');
140. exit;
142. }

Phpexcel Exporting instances of Excel documents 2003 and 2007