phpexcel导出excel的经典实例

3. /**
4. * phpexcel类库导出excel文件
5. * edit: bbs.it-home.org
6. *
7. */
8. require 'php-excel.class.php';//引用谷歌的phpexcel 类
9. $result = mysql_query("SELECT * FROM dingdan"); //查询一个数据表，并返回记录集
10. $data = array( 1 => array ('订单编号', '线路名称'),);
11. while($row = mysql_fetch_array($result)){//把查询的结果循环输出到EXCEL中
12. array_push($data,array($row["dd_bh"], $row["dd_xianlu_name"]));
13. }
14. // generate file (constructor parameters are optional)
15. $xls = new Excel_XML('GB2312', false, '财务报表');
16. $xls->addArray($data);
17. $xls->generateXML('2011010320');
18. ?>

复制代码

附，phpexcel 类 php-excel.class.php 文件代码。

3. class Excel_XML

4. {
5. /**
6. * Header (of document)
7. * @var string
8. */
9. private $header = "/n";
10. /**
11. * Footer (of document)
12. * @var string
13. */
14. private $footer = "
";
15. /**
16. * Lines to output in the excel document
17. * @var array
18. */
19. private $lines = array();
20. /**
21. * Used encoding
22. * @var string
23. */
24. private $sEncoding;
26. /**
27. * Convert variable types
28. * @var boolean
29. */
30. private $bConvertTypes;
32. /**
33. * Worksheet title
34. * @var string
35. */
36. private $sWorksheetTitle;
37. /**
38. * Constructor
39. *
40. * The constructor allows the setting of some additional
41. * parameters so that the library may be configured to
42. * one's needs.
43. *
44. * On converting types:
45. * When set to true, the library tries to identify the type of
46. * the variable value and set the field specification for Excel
47. * accordingly. Be careful with article numbers or postcodes
48. * starting with a '0' (zero)!
49. *
50. * @param string $sEncoding Encoding to be used (defaults to GBK)
51. * @param boolean $bConvertTypes Convert variables to field specification
52. * @param string $sWorksheetTitle Title for the worksheet
53. */
54. public function __construct($sEncoding = 'UTF-8', $bConvertTypes = false, $sWorksheetTitle = 'Table1')
55. {
56. $this->bConvertTypes = $bConvertTypes;
57. $this->setEncoding($sEncoding);
58. $this->setWorksheetTitle($sWorksheetTitle);
59. }
61. /**
62. * Set encoding
63. * @param string Encoding type to set
64. */
65. public function setEncoding($sEncoding)
66. {
67. $this->sEncoding = $sEncoding;
68. }
69. /**
70. * Set worksheet title
71. *
72. * Strips out not allowed characters and trims the
73. * title to a maximum length of 31.
74. *
75. * @param string $title Title for worksheet
76. */
77. public function setWorksheetTitle ($title)
78. {
79. $title = preg_replace ("/[///|:|//|/?|/*|/[|/]]/", "", $title);
80. $title = substr ($title, 0, 31);
81. $this->sWorksheetTitle = $title;
82. }
83. /**
84. * Add row
85. *
86. * Adds a single row to the document. If set to true, self::bConvertTypes
87. * checks the type of variable and returns the specific field settings
88. * for the cell.
89. *
90. * @param array $array One-dimensional array with row content
91. */
92. private function addRow ($array)
93. {
94. $cells = "";
95. foreach ($array as $k => $v):
96. $type = 'String';
97. if ($this->bConvertTypes === true && is_numeric($v)):
98. $type = 'Number';
99. endif;
100. $v = htmlentities($v, ENT_COMPAT, $this->sEncoding);
101. $cells .= "" . $v . "/n";
102. endforeach;
103. $this->lines[] = "/n" . $cells . "/n";
104. }
105. /**
106. * Add an array to the document
107. * @param array 2-dimensional array
108. */
109. public function addArray ($array)
110. {
111. foreach ($array as $k => $v)
112. $this->addRow ($v);
113. }

114. /**

115. * Generate the excel file
116. * @param string $filename Name of excel file to generate (...xls)
117. */
118. public function generateXML ($filename = 'excel-export')
119. {
120. // correct/validate filename
121. $filename = preg_replace('/[^aA-zZ0-9/_/-]/', '', $filename);
123. // deliver header (as recommended in php manual)
124. header("Content-Type: application/vnd.ms-excel; charset=" . $this->sEncoding);
125. header("Content-Disposition: inline; filename=/"" . $filename . ".xls/"");
126. // print out document to the browser
127. // need to use stripslashes for the damn ">"
128. echo stripslashes (sprintf($this->header, $this->sEncoding));
129. echo "/nsWorksheetTitle . "/">/n/n";
130. foreach ($this->lines as $line)
131. echo $line;
132. echo "
/n/n";
133. echo $this->footer;
134. }
135. }
136. ?>

复制代码