php中xls导出乱码如何解决


本篇内容介绍了“php中xls导出乱码如何解决”的有关知识,在实际案例的操作过程中,不少人都会遇到这样的困境,接下来就让小编带领大家学习一下如何处理这些情况吧!希望大家仔细阅读,能够学有所成! php中xls导出乱码的解决办法:1、打开相应的PHP文件;2、在产生乱码的文件中,添加“header(“Content-type:application/vnd.ms-excel;charset=UTF-8”);”语句即可。采用phpmyadmin的处理方式


//这个很关键

相关介绍:

相关介绍:
Content-type类型有

'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'=&g免费云主机域名t;'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导出乱码如何解决”的内容就介绍到这里了,感谢大家的阅读。如果想了解更多行业相关的知识可以关注百云主机网站,小编将为大家输出更多高质量的实用文章!

相关推荐: JS异常抛出和处理的方法是什么

今天小编给大家分享一下JS异常抛出和处理的方法是什么的相关知识点,内容详细,逻辑清晰,相信大部分人都还太了解这方面的知识,所以分享这篇文章给大家参考一下,希望大家阅读完这篇文章后有所收获,下面我们一起来了解一下吧。在 js 中,有时候我们需要处理一些异常或错误…

免责声明:本站发布的图片视频文字,以转载和分享为主,文章观点不代表本站立场,本站不承担相关法律责任;如果涉及侵权请联系邮箱:360163164@qq.com举报,并提供相关证据,经查实将立刻删除涉嫌侵权内容。

(0)
打赏 微信扫一扫 微信扫一扫
上一篇 02/23 14:30
下一篇 02/23 17:42

相关推荐