blocks|key|961585|text|我不确定，但它可能是excel不能处理utf8(可能取决于版本)。但是它可以处理utf16，所以尝试转换字符集。这对我很有效(在excel2002中)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|961586|echo+mb_convert_encoding('Désçàui','utf-16','utf-8');|code-block|syntax|javascript|961587|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I'm not sure, but it may be that excel can not handle utf8(may depend on the version). But it can handle utf16, so try converting the charset.
This works for me(in excel2002):

<pre><code>echo mb_convert_encoding('Désçàui','utf-16','utf-8');
</code></pre>

blocks|key|745708|text|源http://www.mwasif.com/2007/5/download-data-csv-using-php/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|745709|解决方案对我很有效|745710|丹麦人扎胡尔说，|745711|2009年10月7日下午7:23|745712|如果您的内容是UTF-8格式，则不需要转换编码。只需以UTF-8+BOM开头的头文件/输出流即可。|745713|echo+pack("CCC",0xef,0xbb,0xbf);|style|CODE|745714|并且报头应包含编码UTF-8|745715|header(+"Content-type:+application/vnd.ms-excel;+charset=UTF-8"+);|745716|它将像charm一样工作，因为Excel将识别带有BOM字节的文件字符集。|745717|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mwasif.com/2007/5/download-data-csv-using-php/^0|1|1L|0|0|0|0|0|0|0|W|0|0|0|1U|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|D|3|E|5|6|7|17|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|18|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|19|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1A|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|1B|8|@$A|1C|B|1D|N|O]]|9|@]|C|$]]|$1|P|3|Q|5|6|7|1E|8|@]|9|@]|C|$]]|$1|R|3|S|5|6|7|1F|8|@$A|1G|B|1H|N|O]]|9|@]|C|$]]|$1|T|3|U|5|6|7|1I|8|@]|9|@]|C|$]]|$1|V|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]]|W|$X|$5|Y|Z|10|C|$11|12]]]]

Source <a href="http://www.mwasif.com/2007/5/download-data-csv-using-php/" rel="noreferrer">http://www.mwasif.com/2007/5/download-data-csv-using-php/</a>

<h1>Solution worked for me</h1>

Danish Zahur said,

October 7, 2009 @ 7:23 pm

If your contents are in UTF-8 format, then no need to convert encoding. Just start your file/output stream with UTF-8 BOM after headers.

<code>echo pack("CCC",0xef,0xbb,0xbf);</code>

And header should contain encoding UTF-8

<code>header( "Content-type: application/vnd.ms-excel; charset=UTF-8" );</code>

It will work like charm because Excel will recognize file charset with BOM bytes.

blocks|key|961678|text|我不知道你是怎么生成excel文件的。但是，如果您是从HTML输出中执行此操作，则只需在开头添加以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|961679|<meta+http-equiv="content-type"+content="application/xhtml%2Bxml;+charset=UTF-8"+/>|offset|length|style|CODE|961680|问候|961681|entityMap^0|0|0|29|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I don't know how you're generating the excel file. But, if you're doing it from an HTML output, you can just add the following at the begining:

<code>&lt;meta http-equiv="content-type" content="application/xhtml+xml; charset=UTF-8" /&gt;</code>

Regards

blocks|key|961797|text|这行UTF-8+BOM代码让我的UTF-8字符工作得很好：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|961798|+header("Content-type:+application/vnd.ms-excel");
+header("Content-Disposition:+attachment;+filename='".$file_name."'");
+header("Pragma:+no-cache");
+header("Expires:+0");
+echo+"\xEF\xBB\xBF";+//UTF-8+BOM
+echo+$out;|code-block|syntax|javascript|961799|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This UTF-8 BOM line of code made my UTF-8 chars work fine:

<pre><code> header("Content-type: application/vnd.ms-excel");
 header("Content-Disposition: attachment; filename='".$file_name."'");
 header("Pragma: no-cache");
 header("Expires: 0");
 echo "\xEF\xBB\xBF"; //UTF-8 BOM
 echo $out;
</code></pre>

blocks|key|961709|text|将utf8转换为html-entities对我来说非常有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|961710|$str+=+'utf-string+...';
if+(mb_detect_encoding($str+)+==+'UTF-8')+{
+++$str+=+mb_convert_encoding($str+,+"HTML-ENTITIES",+"UTF-8");
}

header('Content-type:+application/x-msdownload;+charset=utf-16');
header('Content-Disposition:+attachment;+filename=companies.xls');
header('Pragma:+no-cache');
header('Expires:+0');

echo+$str+;+|code-block|syntax|javascript|961711|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Converting utf8 to html-entities worked quite nicely for me :

<pre><code>$str = 'utf-string ...';
if (mb_detect_encoding($str ) == 'UTF-8') {
 $str = mb_convert_encoding($str , "HTML-ENTITIES", "UTF-8");
}

header('Content-type: application/x-msdownload; charset=utf-16');
header('Content-Disposition: attachment; filename=companies.xls');
header('Pragma: no-cache');
header('Expires: 0');

echo $str ; 
</code></pre>

blocks|key|961527|text|content-type标头仅与浏览器相关。它们对下载的文件没有影响。保存文件后，应由应用程序决定如何处理文件中的数据。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|961528|首先，您显示的示例不是有效的Excel文件。当遇到它认为是损坏的文件时，Excel可能会切换到某些默认处理，该处理假定为windows-1252或其他单字节字符集。|961529|您必须给Excel一个合适的文件才能打开。或者，也可以使用旧的“输出HTML但另存为XLS”技巧，并在该HTML文件中指定UTF-8编码。|961530|entityMap^0|0|C|0|1O|C|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|R|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|K|$]]

The <code>content-type</code> headers are relevant for the browser only. They have no effect on downloaded files. Once the file is saved, it is up to the application to decide how it treats the data in the file.

The example you show is not a valid Excel file in the first place. When encountering what it must think is a broken file, Excel probably switches to some default processing that assumes <code>windows-1252</code> or some other single-byte character set.

You would have to give Excel a proper file to open. Alternatively, it may be possible to use the old "Output HTML but save as XLS" trick and specify a UTF-8 encoding in that HTML file.

blocks|key|745913|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|745914|<?php
header("Content-Type:+application/vnd.ms-excel");
header('Content-Disposition:+attachment;+filename="sample.xls"');
echo+"
++++<html+xmlns:o=\"urn:schemas-microsoft-com:office:office\"+xmlns:x=\"urn:schemas-microsoft-com:office:excel\"+xmlns=\"http://www.w3.org/TR/REC-html40\">
++++<html>
++++++++<head><meta+http-equiv=\"Content-type\"+content=\"text/html;charset=utf-8\"+/></head>
++++++++<body>
";

echo+"
++++<table>
++++++<tr>
++++++++<th+rowspan=\"2\"+nowrap=\"nowrap\">เลขที่บัญชี</th>
++++++++<th+rowspan=\"2\"+nowrap=\"nowrap\">ชื่อ-สกุล+ลูกค้า</th>
++++++++<th+rowspan=\"2\"+nowrap=\"nowrap\">OS/Balance</th>
++++++++<th+rowspan=\"2\"+nowrap=\"nowrap\">วันที่</th>
++++++++<th+rowspan=\"2\"+nowrap=\"nowrap\">เวลา</th>
++++++++<th+rowspan=\"2\"+nowrap=\"nowrap\">Action+Code</th>
++++++++<th+rowspan=\"2\"+nowrap=\"nowrap\">Amount</th>
++++++++<th+colspan=\"5\"+nowrap=\"nowrap\">ผลการติดตาม</th>
++++++</tr>
++++++<tr>
++++++++<th+nowrap=\"nowrap\">ที่อยู่บ้าน</th>
++++++++<th+nowrap=\"nowrap\">เบอร์โทรบ้าน</th>
++++++++<th+nowrap=\"nowrap\">เบอร์โทรมือถือ</th>
++++++++<th+nowrap=\"nowrap\">ที่อยู่ที่ทำงาน</th>
++++++++<th+nowrap=\"nowrap\">เบอร์โทรที่ทำงาน</th>
++++++</tr>
++++++<tr>
++++++++<td>acc</td>
++++++++<td>name</td>
++++++++<td>balance</td>
++++++++<td>date</td>
++++++++<td>time</td>
++++++++<td>code</td>
++++++++<td>amount</td>
++++++++<td>h-addr</td>
++++++++<td>h-tel</td>
++++++++<td>cell</td>
++++++++<td>w-addr</td>
++++++++<td>w-tel</td>
++++++</tr>
++++</table>
";

echo+"</body></html>";

?>|code-block|syntax|javascript|745915|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

try this

<pre><code>&lt;?php
header("Content-Type: application/vnd.ms-excel");
header('Content-Disposition: attachment; filename="sample.xls"');
echo "
 &lt;html xmlns:o=\"urn:schemas-microsoft-com:office:office\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns=\"http://www.w3.org/TR/REC-html40\"&gt;
 &lt;html&gt;
 &lt;head&gt;&lt;meta http-equiv=\"Content-type\" content=\"text/html;charset=utf-8\" /&gt;&lt;/head&gt;
 &lt;body&gt;
";

echo "
 &lt;table&gt;
 &lt;tr&gt;
 &lt;th rowspan=\"2\" nowrap=\"nowrap\"&gt;เลขที่บัญชี&lt;/th&gt;
 &lt;th rowspan=\"2\" nowrap=\"nowrap\"&gt;ชื่อ-สกุล ลูกค้า&lt;/th&gt;
 &lt;th rowspan=\"2\" nowrap=\"nowrap\"&gt;OS/Balance&lt;/th&gt;
 &lt;th rowspan=\"2\" nowrap=\"nowrap\"&gt;วันที่&lt;/th&gt;
 &lt;th rowspan=\"2\" nowrap=\"nowrap\"&gt;เวลา&lt;/th&gt;
 &lt;th rowspan=\"2\" nowrap=\"nowrap\"&gt;Action Code&lt;/th&gt;
 &lt;th rowspan=\"2\" nowrap=\"nowrap\"&gt;Amount&lt;/th&gt;
 &lt;th colspan=\"5\" nowrap=\"nowrap\"&gt;ผลการติดตาม&lt;/th&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
 &lt;th nowrap=\"nowrap\"&gt;ที่อยู่บ้าน&lt;/th&gt;
 &lt;th nowrap=\"nowrap\"&gt;เบอร์โทรบ้าน&lt;/th&gt;
 &lt;th nowrap=\"nowrap\"&gt;เบอร์โทรมือถือ&lt;/th&gt;
 &lt;th nowrap=\"nowrap\"&gt;ที่อยู่ที่ทำงาน&lt;/th&gt;
 &lt;th nowrap=\"nowrap\"&gt;เบอร์โทรที่ทำงาน&lt;/th&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
 &lt;td&gt;acc&lt;/td&gt;
 &lt;td&gt;name&lt;/td&gt;
 &lt;td&gt;balance&lt;/td&gt;
 &lt;td&gt;date&lt;/td&gt;
 &lt;td&gt;time&lt;/td&gt;
 &lt;td&gt;code&lt;/td&gt;
 &lt;td&gt;amount&lt;/td&gt;
 &lt;td&gt;h-addr&lt;/td&gt;
 &lt;td&gt;h-tel&lt;/td&gt;
 &lt;td&gt;cell&lt;/td&gt;
 &lt;td&gt;w-addr&lt;/td&gt;
 &lt;td&gt;w-tel&lt;/td&gt;
 &lt;/tr&gt;
 &lt;/table&gt;
";

echo "&lt;/body&gt;&lt;/html&gt;";

?&gt;
</code></pre>

blocks|key|745946|text|试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|745947|header('Content-Transfer-Encoding:+binary');
header("Content-Type:+application/octet-stream");+
header("Content-Transfer-Encoding:+binary");+
header('Expires:+'.gmdate('D,+d+M+Y+H:i:s').'+GMT');+
header('Content-Disposition:+attachment;+filename+=+"Export+'.date("Y-m-d").'.xls"');+
header('Pragma:+no-cache');+

//these+characters+will+make+correct+encoding+to+excel+
echo+chr(255).chr(254).iconv("UTF-8",+"UTF-16LE//IGNORE",+$out);+|code-block|syntax|javascript|745948|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this:

<pre><code>header('Content-Transfer-Encoding: binary');
header("Content-Type: application/octet-stream"); 
header("Content-Transfer-Encoding: binary"); 
header('Expires: '.gmdate('D, d M Y H:i:s').' GMT'); 
header('Content-Disposition: attachment; filename = "Export '.date("Y-m-d").'.xls"'); 
header('Pragma: no-cache'); 

//these characters will make correct encoding to excel 
echo chr(255).chr(254).iconv("UTF-8", "UTF-16LE//IGNORE", $out); 
</code></pre>

<pre><code>ob_start();

echo 'Désçàui';

header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-type: application/x-msexcel; charset=utf-8");
header("Content-Disposition: attachment; filename=Test.xls"); 
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private",false); 

ob_end_flush();
</code></pre>

What I'm getting in the excel file is <code>DÃ©sÃ§Ã ui</code>

However, I do get Désçàui when I try

<pre><code>ob_start();
echo 'Désçàui';
header("Content-Type: text/html; charset=utf-8");
ob_end_flush();
</code></pre>

Any help experts?

PS. The file is saved in DW with Title/Encoding Unicode(Utf-8).

php header excel and utf-8

ob_start();echo 'Désçàui';header("Content-Type:   application/vnd.ms-excel; charset=utf-8");header("Content-type:   application/x-msexcel; charset=utf-8");header("Content-Disposition: attachment; file

问php标题excel和utf-8
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问php标题excel和utf-8EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问php标题excel和utf-8
EN