• 技术文章 >后端开发 >PHP问题

    php中xls导出乱码怎么办

    藏色散人藏色散人2022-11-24 09:20:03原创140

    php中xls导出乱码的解决办法:1、打开相应的PHP文件;2、在产生乱码的文件中,添加“header("Content-type:application/vnd.ms-excel;charset=UTF-8");”语句即可。

    php入门到就业线上直播课:进入学习

    本教程操作环境:Windows7系统、PHP8.1版、Dell G3电脑。

    php中xls导出乱码怎么办?

    采用phpmyadmin的处理方式

    <?php 
    header("Content-type:application/vnd.ms-excel;charset=UTF-8"); 
    header("Content-Disposition: attachment; filename=$filename"); 
    header("Pragma: no-cache"); 
    header("Expires: 0"); 
    ?> 
    //这个很关键

    相关介绍:

    Content-type类型有

    <?php
    $mimetypes = array(
    'ez' => 'application/andrew-inset',
    'hqx' => 'application/mac-binhex40',
    'cpt' => 'application/mac-compactpro',
    'doc' => 'application/msword',
    'bin' => 'application/octet-stream',
    'dms' => 'application/octet-stream',
    'lha' => 'application/octet-stream',
    'lzh' => 'application/octet-stream',
    'exe' => 'application/octet-stream',
    'class' => 'application/octet-stream',
    'so' => 'application/octet-stream',
    'dll' => 'application/octet-stream',
    'oda' => 'application/oda',
    'pdf' => 'application/pdf',
    'ai' => 'application/postscript',
    'eps' => 'application/postscript',
    'ps' => 'application/postscript',
    'smi' => 'application/smil',
    'smil' => 'application/smil',
    'mif' => 'application/vnd.mif',
    'xls' => 'application/vnd.ms-excel',
    'ppt' => 'application/vnd.ms-powerpoint',
    'wbxml' => 'application/vnd.wap.wbxml',
    'wmlc' => 'application/vnd.wap.wmlc',
    'wmlsc' => 'application/vnd.wap.wmlscriptc',
    'bcpio' => 'application/x-bcpio',
    'vcd' => 'application/x-cdlink',
    'pgn' => 'application/x-chess-pgn',
    'cpio' => 'application/x-cpio',
    'csh' => 'application/x-csh',
    'dcr' => 'application/x-director',
    'dir' => 'application/x-director',
    'dxr' => 'application/x-director',
    'dvi' => 'application/x-dvi',
    'spl' => 'application/x-futuresplash',
    'gtar' => 'application/x-gtar',
    'hdf' => 'application/x-hdf',
    'js' => 'application/x-javascript',
    'skp' => 'application/x-koan',
    'skd' => 'application/x-koan',
    'skt' => 'application/x-koan',
    'skm' => 'application/x-koan',
    'latex' => 'application/x-latex',
    'nc' => 'application/x-netcdf',
    'cdf' => 'application/x-netcdf',
    'sh' => 'application/x-sh',
    'shar' => 'application/x-shar',
    'swf' => 'application/x-shockwave-flash',
    'sit' => 'application/x-stuffit',
    'sv4cpio' => 'application/x-sv4cpio',
    'sv4crc' => 'application/x-sv4crc',
    'tar' => 'application/x-tar',
    'tcl' => 'application/x-tcl',
    'tex' => 'application/x-tex',
    'texinfo' => 'application/x-texinfo',
    'texi' => 'application/x-texinfo',
    't' => 'application/x-troff',
    'tr' => 'application/x-troff',
    'roff' => 'application/x-troff',
    'man' => 'application/x-troff-man',
    'me' => 'application/x-troff-me',
    'ms' => 'application/x-troff-ms',
    'ustar' => 'application/x-ustar',
    'src' => 'application/x-wais-source',
    'xhtml' => 'application/xhtml+xml',
    'xht' => 'application/xhtml+xml',
    'zip' => 'application/zip',
    'au' => 'audio/basic',
    'snd' => 'audio/basic',
    'mid' => 'audio/midi',
    'midi' => 'audio/midi',
    'kar' => 'audio/midi',
    'mpga' => 'audio/mpeg',
    'mp2' => 'audio/mpeg',
    'mp3' => 'audio/mpeg',
    'aif' => 'audio/x-aiff',
    'aiff' => 'audio/x-aiff',
    'aifc' => 'audio/x-aiff',
    'm3u' => 'audio/x-mpegurl',
    'ram' => 'audio/x-pn-realaudio',
    'rm' => 'audio/x-pn-realaudio',
    'rpm' => 'audio/x-pn-realaudio-plugin',
    'ra' => 'audio/x-realaudio',
    'wav' => 'audio/x-wav',
    'pdb' => 'chemical/x-pdb',
    'xyz' => 'chemical/x-xyz',
    'bmp' => 'image/bmp',
    'gif' => 'image/gif',
    'ief' => 'image/ief',
    'jpeg' => 'image/jpeg',
    'jpg' => 'image/jpeg',
    'jpe' => 'image/jpeg',
    'png' => 'image/png',
    'tiff' => 'image/tiff',
    'tif' => 'image/tiff',
    'djvu' => 'image/vnd.djvu',
    'djv' => 'image/vnd.djvu',
    'wbmp' => 'image/vnd.wap.wbmp',
    'ras' => 'image/x-cmu-raster',
    'pnm' => 'image/x-portable-anymap',
    'pbm' => 'image/x-portable-bitmap',
    'pgm' => 'image/x-portable-graymap',
    'ppm' => 'image/x-portable-pixmap',
    'rgb' => 'image/x-rgb',
    'xbm' => 'image/x-xbitmap',
    'xpm' => 'image/x-xpixmap',
    'xwd' => 'image/x-xwindowdump',
    'igs' => 'model/iges',
    'iges' => 'model/iges',
    'msh' => 'model/mesh',
    'mesh' => 'model/mesh',
    'silo' => 'model/mesh',
    'wrl' => 'model/vrml',
    'vrml' => 'model/vrml',
    'css' => 'text/css',
    'html' => 'text/html',
    'htm' => 'text/html',
    'asc' => 'text/plain',
    'txt' => 'text/plain',
    'rtx' => 'text/richtext',
    'rtf' => 'text/rtf',
    'sgml' => 'text/sgml',
    'sgm' => 'text/sgml',
    'tsv' => 'text/tab-separated-values',
    'wml' => 'text/vnd.wap.wml',
    'wmls' => 'text/vnd.wap.wmlscript',
    'etx' => 'text/x-setext',
    'xsl' => 'text/xml',
    'xml' => 'text/xml',
    'mpeg' => 'video/mpeg',
    'mpg' => 'video/mpeg',
    'mpe' => 'video/mpeg',
    'qt' => 'video/quicktime',
    'mov' => 'video/quicktime',
    'mxu' => 'video/vnd.mpegurl',
    'avi' => 'video/x-msvideo',
    'movie' => 'video/x-sgi-movie',
    'ice' => 'x-conference/x-cooltalk',
    );
    ?>

    推荐学习:《PHP视频教程

    以上就是php中xls导出乱码怎么办的详细内容,更多请关注php中文网其它相关文章!

    声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn核实处理。

    前端(VUE)零基础到就业课程:点击学习

    清晰的学习路线+老师随时辅导答疑

    自己动手写 PHP MVC 框架:点击学习

    快速了解MVC架构、了解框架底层运行原理

    专题推荐:乱码 xls php
    上一篇:nginx php403错误怎么解决 下一篇:自己动手写 PHP MVC 框架(40节精讲/巨细/新人进阶必看)

    相关文章推荐

    • ❤️‍🔥共22门课程,总价3725元,会员免费学• ❤️‍🔥接口自动化测试不想写代码?• bat执行php中文乱码怎么办• php Edge下载文件名乱码怎么办• php parse_ini_string() 乱码怎么办• php导出mysql csv乱码问题怎么解决• php 导入csv乱码问题怎么办
    1/1

    PHP中文网