Problem with php exporting data in excel format_PHP tutorial

Solve 2 problems:
1. Text data such as ID cards are automatically converted to scientific notation problem.
2. The problem of garbled Chinese characters

The principle of excel exporting from the web page. When we send this data to the client, we want the client program (browser) to read it in excel format, so set the mime type to: application/vnd.ms-excel, when excel reads the file The data will be presented in the format of each cell. If the cell does not have a specified format, Excel will present the data of the cell in the default format. This provides us with space to customize the data format. Of course, we must use a format supported by excel. Here are some commonly used formats:

1) Text: vnd.ms-excel.numberformat:@
2) Date: vnd.ms-excel.numberformat:yyyy/mm/dd
3) Number: vnd.ms- excel.numberformat:#,##0.00
4) Currency: vnd.ms-excel.numberformat:￥#,##0.00
5) Percentage: vnd.ms-excel.numberformat: #0.00%

You can also customize these formats. For example, you can define the year and month as: yy-mm, etc. So knowing these formats, how to add these formats to the cell? It's very simple, we just need to add the style to the corresponding tag pair (that is, the closing tag). For example,

, add a style to the label pair as follows: 410522198402161833> ;
Similarly, we can also add styles to

, and we can also add styles to , ; when we When styles are added to both the parent tag pair and the child tag pair, which style will the data be presented in? After testing, it will be presented in the style closest to the data.

For example, the style of

in the ID card column:

echo "

".$printable."n";

Copy Code The code is as follows:

$filename=iconv("UTF-8", "GB2312//IGNORE","会员名.xls");//date('Y-m-d-H-i-s').".xls";
header("Content-type:application/vnd.ms-excel");
            Header("Accept-Ranges:bytes");
            Header("Content-Disposition:attachment;filename=".$filename); //$filename导出的文件名
            header("Pragma: no-cache");
            header("Expires: 0");

echo '    xmlns:x="urn:schemas-microsoft-com:office:excel"
    xmlns="http://www.w3.org/TR/REC-html40">