excel utf-8 php code example

Example 1: excel utf-8 php

// --- 3 rows for encoding utf-8
header('Content-Encoding: UTF-8'); // vilh, change to UTF-8!
header("Content-type: application/x-msexcel; charset=utf-8");  // vilh, chang
fputs ($fp, "\xEF\xBB\xBF"); // vilh, change to UTF-8!

// -------------------
header('Content-Encoding: UTF-8'); // vilh, change to UTF-8!
header("Content-type: application/x-msexcel; charset=utf-8");  // vilh, change to UTF-8!
header('Content-Disposition: attachment; filename="'.$fileName.'.csv"');
header('Cache-Control: max-age=0');

// for browser down
$fp = fopen('php://output', 'a');

fputs ($fp, "\xEF\xBB\xBF"); // vilh, change to UTF-8!

//header
foreach ($headlist as $key => $value) {
  $headlist[$key] = $value;	// vilh, change to UTF-8
}

fputcsv($fp, $headlist);

Example 2: csv utf-8 excel into php

mb_convert_encoding($csv, 'UTF-16LE', 'UTF-8');

Example 3: csv utf-8 excel into php

chr(255) . chr(254)