How to write csv file and open in MS.Excel in charset UTF-8

Question

I have detect my value to write is Thai language and I will write to CSV file but when I use fwrite and save .CSV file and open this CSV file in Excel.I see my text about "เธฅเธนเธเธเธฅเธดเนเธ,เธชเธฃเนเธฒเธเธฅเธฒเธข" Below this code

$xfile =fopen($filename,"w");
foreach( $data as $itm ){
     $outstr="";
     foreach($itm as $key=>$str){
            $val =str_replace("\r\n","",$str);
            val =str_replace("\t\t","",$val);
            $val =str_replace('"',"'",$val);
            $outstr=$outstr.'"'.$val.'"'.$clm;
            //dump(mb_detect_encoding($outstr));die(); --Result UTF-8
     }
$outstr=substr($outstr,0,strlen($outstr)-1);
fwrite($xfile,$outstr."\r\n"); //Newline
fclose($xfile);

I feel stupid Or i forgot something. Please help

Use a library to write csv/excel file properly. github.com/PHPOffice — Mark
– Mark, Commented Nov 17, 2017 at 3:31
you can browse sample directory. github.com/PHPOffice/PhpSpreadsheet/blob/develop/samples/Basic/… I'm not using symfony but installing phpspreadsheet with composer, using its namespace and calling it should work. try it in your controller first. Ived been using it for how many years. Its best for spreadsheets like csv. — Mark
– Mark, Commented Nov 17, 2017 at 3:45

patipat chewprecha · Accepted Answer · 2017-11-17 03:47:43Z

0

I use BOM with UTF-8 and insert after value. I see from this link

$xfile =fopen($filename,"w");
$BOM = "\xEF\xBB\xBF"; // UTF-8 BOM
fwrite($xfile, $BOM);

answered Nov 17, 2017 at 3:47

patipat chewprecha

2852 gold badges7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

スージン · Accepted Answer · 2017-11-17 05:06:45Z

0

Try mb_convert_encoding before you write.

$xfile =fopen($filename,"w");
foreach( $data as $itm ){
     $outstr="";
     foreach($itm as $key=>$str){
            $val =str_replace("\r\n","",$str);
            val =str_replace("\t\t","",$val);
            $val =str_replace('"',"'",$val);
            $outstr=$outstr.'"'.$val.'"'.$clm;
            //dump(mb_detect_encoding($outstr));die(); --Result UTF-8
     }
$outstr=substr($outstr,0,strlen($outstr)-1);
$outstr= mb_convert_encoding($outstr, "UTF-8");
fwrite($xfile,$outstr."\r\n"); //Newline
fclose($xfile);

Check detail here PHP_mb_convert_encoding

answered Nov 17, 2017 at 5:06

スージン

1539 bronze badges

Collectives™ on Stack Overflow

How to write csv file and open in MS.Excel in charset UTF-8

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related