php header excel and utf-8

by

Source http://www.mwasif.com/2007/5/download-data-csv-using-php/

Solution worked for me

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.

echo pack("CCC",0xef,0xbb,0xbf);

And header should contain encoding UTF-8

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

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

More Related Contents:

  1. How do I remove  from the beginning of a file?
  2. How do I use filesystem functions in PHP, using UTF-8 strings?
  3. How to remove all non printable characters in a string?
  4. Detect encoding and make everything UTF-8
  5. UTF-8 BOM signature in PHP files
  6. Elegant way to search for UTF-8 files with BOM?
  7. Convert utf8-characters to iso-88591 and back in PHP
  8. PHP: Convert unicode codepoint to UTF-8
  9. Unable to retrieve UTF-8 accented characters from Access via PDO_ODBC
  10. Getting ’ instead of an apostrophe(‘) in PHP
  11. How to set UTF-8 encoding for a PHP file
  12. is PHP str_word_count() multibyte safe?
  13. ‘Malformed UTF-8 characters, possibly incorrectly encoded’ in Laravel
  14. strlen() and UTF-8 encoding
  15. How to skip invalid characters in XML file using PHP
  16. json_encode() non utf-8 strings?
  17. UTF-8 encoding for subject in contact form email
  18. How to iterate UTF-8 string in PHP?
  19. URL Decoding in PHP
  20. How can I detect a malformed UTF-8 string in PHP?
  21. php substr() function with utf-8 leaves � marks at the end
  22. How to check if letter is upper or lower in PHP?
  23. utf8_(en|de)code removed from php7?
  24. PHP json_encode json_decode UTF-8
  25. Ensuring valid UTF-8 in PHP
  26. UTF-8 in PHP regular expressions [duplicate]
  27. fwrite() and UTF8
  28. The ultimate emoji encoding scheme
  29. UTF8 Filenames in PHP and Different Unicode Encodings
  30. How do I detect if have to apply UTF-8 decode or encode on a string?

Leave a Comment