UTF-8 CSV for Excel

user-pic
By Pank on March 24, 2010 2:19 PM 0 Vote 0 Votes

本來以為 Excel 不支援 UTF-8 的 CSV,
一直都是轉成 Big5 輸出, 但是遇到像「喆」這種 Big5 中沒有的字, 就會有掉字問題.

原來只要在加入 BOM 檔頭, Excel 就可以正常讀取,
PHP 加入 fputs($fp,"\xEF\xBB\xBF");

但是 Excel 似乎沒辦法存 UTF-8 格式的 CSV.

ref. PHP匯出 Excel可讀的UTF-8編碼CSV檔案

Categories:

Leave a comment

About this Entry

This page contains a single entry by Pank published on March 24, 2010 2:19 PM.

Pure-FTP uploadscript was the previous entry in this blog.

Using Google Map API to Get Latitude/Longitude is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Categories

Monthly Archives