PHP Export data to Excel class

Export data to Excel, welcome to make Bricks /** * Exported to Excel file (generally exported in Chinese will be garbled, need to encode conversion) * Use the following method * $excel = new Excel (); * $excel->addheader (Array (' column 1 ', ' column 2 ', ' column 3 ', ' column 4 ')); * $excel->addbody ( Array Array (' Data 1 ', ' Data 2 ', ' Data 3 ', ' Data 4 '), Array (' Data 1 ', ' Data 2 ', ' Data 3 ', ' Data 4 '), Array (' Data 1 ', ' Data 2 ', ' Data 3 ', ' Data 4 '), Array (' Data 1 ', ' Data 2 ', ' Data 3 ', ' Data 4 ') ) ); * $excel->download (); */ Class excel{ Private $head; Private $body; /** * * @param type $arr one-dimensional array */ Public Function AddHeader ($arr) { foreach ($arr as $headVal) { $headVal = $this->charset ($headVal); $this->head. = "{$headVal}\t"; } $this->head. = "\ n"; } /** * * @param type $arr two-dimensional array */ Public Function Addbody ($arr) { foreach ($arr as $arrBody) { foreach ($arrBody as $bodyVal) { $bodyVal = $this->charset ($bodyVal); $this->body. = "{$bodyVal}\t"; } $this->body. = "\ n"; } } /** * Download Excel file */ Public Function downLoad ($filename = ") { if (! $filename) $filename = Date (' Ymdhis ', Time ()). XLS '; Header ("Content-type:application/vnd.ms-excel"); Header ("Content-disposition:attachment;filename= $filename"); Header ("content-type:charset=gb2312"); if ($this->head) Echo $this->head; Echo $this->body; } /** * Encoding Conversion * @param type $string * @return String */ Public Function CharSet ($string) { Return Iconv ("Utf-8", "gb2312", $string); } } ?> Copy Code

