Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PHP exports data to excel file. PHP exports excel garbled problem.

PHP exports data to excel file. PHP exports excel garbled problem.

WBOY
Release： 2016-07-25 08:56:12
Original
976 people have browsed it
  2. /**
  3. * Export excel file
  4. * by bbs.it-home.org
  5. */
  6. function xlsBOF() {
  7. echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
  8. return;
  9. }
  10. function xlsEOF() {
  11. echo pack("ss", 0x0A, 0x00);
  12. return;
  13. }
  14. function xlsWriteNumber($Row, $Col, $Value) {
  15. echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
  16. echo pack("d", $Value);
  17. return;
  18. }
  19. function xlsWriteLabel($Row, $Col, $Value) {
  20. $Value = iconv("UTF-8 ", "gb2312", $Value); //Add this statement to solve the garbled problem of exported excel files 20110629
  21. $L = strlen($Value);
  22. echo pack("ssssss", 0x204, 8 + $L, $ Row, $Col, 0x0, $L);
  23. echo $Value;
  24. return;
  25. }
  26. include "connection.php";
  27. $sql = "select ledger_name,ledger_sex ,ledger_age ,ledger_add from ps_ledger_11";
  28. $query = mysql_query($sql);
  29. // File header
  30. header("Pragma: public");
  31. header("Expires: 0");
  32. header("Cache-Control: must-revalidate, post-check=0, pre -check=0");
  33. header("Content-Type: application/force-download");
  34. header("Content-Type: application/octet-stream"); ​​
  35. header("Content-Type: application/download ");
  36. header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
  37. header("Content-Disposition: attachment;filename=Police Office Auxiliary Police Statistics Table.xls ") ;
  38. //header("Content-Disposition: inline; filename="" . $filename . ".xls"");
  39. //iconv("utf-8", "gb2312", $filename);//Solution Garbled characters caused by files ".xls"");
  40. header("Content-Transfer-Encoding: binary ");
  41. // Add data to the table
  42. xlsBOF();
  43. xlsWriteLabel(1,0,"Column Name") ;
  44. xlsWriteLabel(1,1,"Column Name");
  45. xlsWriteLabel(1,2,"Column Name");
  46. xlsWriteLabel(1,3,"Column Name");
  47. xlsWriteLabel(1,4,"Column Name ");
  48. $xlsRow = 1;
  49. while($array = mysql_fetch_array($query)) {
  50. ++$i;
  51. xlsWriteNumber($xlsRow,0,"$i");
  52. xlsWriteNumber($xlsRow,0, "$array[0]");
  53. xlsWriteLabel($xlsRow,1,"$array[1]");
  54. xlsWriteLabel($xlsRow,2,"$array[2]");
  55. xlsWriteLabel($xlsRow,3 ,"$array[3]");
  56. xlsWriteLabel($xlsRow,4,"$array[4]");
  57. $xlsRow++;
  58. }
  59. xlsEOF();
  60. exit();
  61. //20110629 Test passed at night . Column names are not displayed? Others are OK.
  62. ?>
Copy code


Related labels：
php导出数据到excel文件 php导出excel乱码问题
source：php.cn
Previous article：PHP code to determine where the search engine is coming from and then jump to it Next article：PHP lists the implementation code of all subdirectories in the directory
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Modify PHP array to escape single quotes I'm uploading a .xlsx file to a website and reading it into an array and then inserting it...
From 2024-04-01 20:35:28
0
1
304
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template