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: 410522198402161833Similarly, we can also add styles to

For example, the style of in the ID card column:

echo "".$printable."n";

$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">
 
   
   
   

';
echo "
     
     
     
";
            foreach ($list as $v)
            {
                 echo "";
                 echo "";
                 echo "";
                 echo "";
             echo "";
            }
            echo "

".iconv("UTF-8", "GB2312//IGNORE","会员名")."	".iconv("UTF-8", "GB2312//IGNORE","账号")."	".iconv("UTF-8", "GB2312//IGNORE","联系人")."
".iconv("UTF-8", "GB2312//IGNORE", $v["user_name"])."	".$v["account_id"]."	".iconv("UTF-8", "GB2312//IGNORE", $v["contact_name"])."

";