Advanced Search

Export UTF-8 data in excel with correct encoding

/ Published in: PHP
Save to your folder(s)
If you want to export some utf-8 data into csv/tsv that will be readable by excel with correct encoding you must add special non vissable characters at the begining of file

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. <?php 
  2.  
  3. $data = "Some utf-8 characters ąćżźćł" 
  4.  
  5. header("Content-Type: application/octet-stream"); 
  6. header("Content-Transfer-Encoding: binary"); 
  7. header('Expires: '.gmdate('D, d M Y H:i:s').' GMT'); 
  8. header('Content-Disposition: attachment; filename = "Export '.date("Y-m-d").'.tsv"'); 
  9. header('Pragma: no-cache'); 
  10.  
  11. //these characters will make correct encoding to excel 
  12. echo chr(255).chr(254).iconv("UTF-8", "UTF-16LE//IGNORE", $data); 
  13.  
  14. ?>

URL: http://www.php.net/manual/en/function.iconv.php#104287

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.