在PHP项目中xls导出乱码的处理方式是什么
导读：今天这篇给大家分享的知识是“在PHP项目中xls导出乱码的处理方式是什么”,小编觉得挺不错的，对大家学习或是工作可能会有所帮助，因此分享发大家做个参考，下文的讲解详细，步骤过程清晰，希望这篇“在PHP项目中xls导出乱码的处理方式是什么”文...
今天这篇给大家分享的知识是“在PHP项目中xls导出乱码的处理方式是什么”,小编觉得挺不错的，对大家学习或是工作可能会有所帮助，因此分享发大家做个参考，下文的讲解详细，步骤过程清晰，希望这篇“在PHP项目中xls导出乱码的处理方式是什么”文章能帮助大家解决问题。
php中xls导出乱码的解决办法：1、打开相应的PHP文件；2、在产生乱码的文件中，添加“header("Content-type:application/vnd.ms-excel; charset=UTF-8"); ”语句即可。
本教程操作环境：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项目中xls导出乱码的处理方式是什么”已经有了进一步的了解，更多相关的问题，欢迎关注网络或到官网咨询客服。
声明：本文内容由网友自发贡献，本站不承担相应法律责任。对本内容有异议或投诉，请联系2913721942#qq.com核实处理，我们将尽快回复您，谢谢合作！
若转载请注明出处： 在PHP项目中xls导出乱码的处理方式是什么
本文地址： https://pptw.com/jishu/650396.html