Data export Excel table feature

The main principle is the PHP code to generate Excel files, the output content to ', ' separated, automatically identify the comma-delimited content into Excel within the different tables, need to break the line with the escape character \ n, the output of the Chinese need to convert the encoding utf-8 to GBK.

Header ("Content-type:application/vnd.ms-excel"); Header ("content-disposition:attachment;filename=pay-". Time (). ". XLS "), header (' Pragma:no-cache '), header (' expires:0 '), foreach ($datas as $val) {echo iconv (' UTF-8 ', ' Gbk//ignore ', Implode ("\ T", $val)). " \ n ";}

Data export Excel table feature