php
后端开发-PHP问题
社交购物网站源码,ubuntu 挂载和卸载,tomcat基于什么原理图,有趣的爬虫机制,ui文件如何在php中使用,随州seo分析lzw
本文操作环境：Windows7 系统、PHP7.1版，DELL G3电脑微信调用扫一扫源码,vscode ctr d,ubuntu 草图大师,tomcat平滑升级,sqlite2.21,shopnc商家入驻插件,前端最基础的框架,selenium爬虫谷歌,php == 和 ===,百度网站seo,手机网站css模板,网页菜单样式,t4 模板 mssql,支付成功页面代码,后台权限管理系统 1.0,人人商城小程序diy前端lzw
php excel怎么设置表格编码？ftp上传源码目录,整么调整vscode的字体,麒麟os ubuntu,tomcat配置在idea,无锡爬虫ip,PHP个人博客达水杨酸,seo就是搜索引擎优化lzw
PHPExcel导出excel表格及中文乱码解决办法这是我写来自己看的，会不断更新，能搜到的都是有缘人~
GitHub下载地址：https://github.com/PHPOffice/PHPExcel
setActiveSheetIndex(0);//设置sheet的name$getActiveSheet = $objPHPExcel->getActiveSheet();$getActiveSheet->setTitle('Sheet名称');//设置单元格的值$getActiveSheet->setCellValue('A1', '姓名');$getActiveSheet->setCellValue('B1', '部门');$getActiveSheet->setCellValue('C1', '工资');//合并单元格$getActiveSheet->mergeCells('C1:D1');//横向合并 纵向同理//设置单元格填充颜色$getActiveSheet->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);$getActiveSheet->getStyle('A1')->getFill()->getStartColor()->setARGB('000099FF');//设置字体样式$getActiveSheet->setCellValue('A2', setMyFontStyle('张三'));$getActiveSheet->setCellValue('B2', setMyFontStyle('开发部'));$getActiveSheet->setCellValue('C2', setMyFontStyle('9999'));//设置文字水平居左(HORIZONTAL_LEFT，默认)、中(HORIZONTAL_CENTER)、右(HORIZONTAL_RIGHT)$getActiveSheet->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//设置文字垂直居中$getActiveSheet->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);//设置自适应宽度$letter = ['A', 'B', 'C'];for($z=0;$zgetColumnDimension($letter[$z])->setAutoSize(true);}//设置固定宽度$getActiveSheet->getColumnDimension('A')->setWidth(20);//清除缓冲区，不加这句会报错ob_end_clean();//输出header("Pragma: public");header("Expires: 0");header("Cache-Control:must-revalidate, post-check=0, pre-check=0");header("Content-Type:application/force-download");header("Content-Type:application/vnd.ms-execl");header("Content-Type:application/octet-stream");header("Content-Type:application/download");header('Content-Type:text/html;Charset=utf-8;');header('Content-Disposition:attachment;filename=表格.xlsx"');header("Content-Transfer-Encoding:binary");$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');$objWriter->save('php://output');exit;//设置字体样式function setMyFontStyle($text){$objRichText = new PHPExcel_RichText();$objRichText->createText("");$objPayable = $objRichText->createTextRun($text);$objPayable->getFont()->setBold(true);$objPayable->getFont()->setItalic(true);$objPayable->getFont()->setColor( new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_RED ) );return $objRichText;}//解决导出中文乱码，按需使用function gbkToUtf8($gbk){$utf8 = iconv('GB2312', 'UTF-8', $gbk);return $utf8;}//解决导出中文乱码，按需使用function utf8ToGbk($utf8){$gbk = iconv('UTF-8', 'GB2312', $utf8);return $gbk;}《PHP视频教学》