php导出excel乱码的解决办法：首先打开相应的PHP文件；然后在代码header前面加上“ob_end_clean()”函数，清除缓冲区即可解决乱码问题。
解决phpexcel导出到xls文件出现乱码
解决方法如下所示：
findAll($sql); //echo $result[1][&＃39;sn&＃39;]; //创建一个excel对象 $objPHPExcel = new PHPExcel(); // Set properties $objPHPExcel->getProperties()->setCreator("ctos") ->setLastModifiedBy("ctos") ->setTitle("Office 2007 XLSX Test Document") ->setSubject("Office 2007 XLSX Test Document") ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") ->setKeywords("office 2007 openxml php") ->setCategory("Test result file"); //set width $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;A&＃39;)->setWidth(8); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;B&＃39;)->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;C&＃39;)->setWidth(25); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;D&＃39;)->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;E&＃39;)->setWidth(50); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;F&＃39;)->setWidth(10); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;G&＃39;)->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;H&＃39;)->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;I&＃39;)->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension(&＃39;J&＃39;)->setWidth(30); //设置行高度 $objPHPExcel->getActiveSheet()->getRowDimension(&＃39;1&＃39;)->setRowHeight(22); $objPHPExcel->getActiveSheet()->getRowDimension(&＃39;2&＃39;)->setRowHeight(20); //set font size bold $objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10); $objPHPExcel->getActiveSheet()->getStyle(&＃39;A2:J2&＃39;)->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->getStyle(&＃39;A2:J2&＃39;)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(&＃39;A2:J2&＃39;)->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); //设置水平居中 $objPHPExcel->getActiveSheet()->getStyle(&＃39;A1&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); $objPHPExcel->getActiveSheet()->getStyle(&＃39;A&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(&＃39;B&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(&＃39;D&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(&＃39;F&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(&＃39;G&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(&＃39;H&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(&＃39;I&＃39;)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); // $objPHPExcel->getActiveSheet()->mergeCells(&＃39;A1:J1&＃39;); // set table header content $objPHPExcel->setActiveSheetIndex(0) ->setCellValue(&＃39;A1&＃39;, &＃39;订单数据汇总 时间:&＃39; . date(&＃39;Y-m-d H:i:s&＃39;)) ->setCellValue(&＃39;A2&＃39;, &＃39;订单ID&＃39;) ->setCellValue(&＃39;B2&＃39;, &＃39;下单人&＃39;) ->setCellValue(&＃39;C2&＃39;, &＃39;客户名称&＃39;) ->setCellValue(&＃39;D2&＃39;, &＃39;下单时间&＃39;) ->setCellValue(&＃39;E2&＃39;, &＃39;需求机型&＃39;) ->setCellValue(&＃39;F2&＃39;, &＃39;需求数量&＃39;) ->setCellValue(&＃39;G2&＃39;, &＃39;需求交期&＃39;) ->setCellValue(&＃39;H2&＃39;, &＃39;确认BOM料号&＃39;) ->setCellValue(&＃39;I2&＃39;, &＃39;PMC确认交期&＃39;) ->setCellValue(&＃39;J2&＃39;, &＃39;PMC交货备注&＃39;); // Miscellaneous glyphs, UTF-8 for ($i = 0; $i
getActiveSheet(0)->setCellValue(&＃39;A&＃39; . ($i + 3), $result[$i][&＃39;id&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;B&＃39; . ($i + 3), $result[$i][&＃39;realname&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;C&＃39; . ($i + 3), $result[$i][&＃39;customer_name&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;D&＃39; . ($i + 3), $OrdersData[$i][&＃39;create_time&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;E&＃39; . ($i + 3), $result[$i][&＃39;require_product&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;F&＃39; . ($i + 3), $result[$i][&＃39;require_count&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;G&＃39; . ($i + 3), $result[$i][&＃39;require_time&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;H&＃39; . ($i + 3), $result[$i][&＃39;product_bom_encoding&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;I&＃39; . ($i + 3), $result[$i][&＃39;delivery_time&＃39;]); $objPHPExcel->getActiveSheet(0)->setCellValue(&＃39;J&＃39; . ($i + 3), $result[$i][&＃39;delivery_memo&＃39;]); $objPHPExcel->getActiveSheet()->getStyle(&＃39;A&＃39; . ($i + 3) . &＃39;:J&＃39; . ($i + 3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(&＃39;A&＃39; . ($i + 3) . &＃39;:J&＃39; . ($i + 3))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getRowDimension($i + 3)->setRowHeight(16); } // Rename sheet $objPHPExcel->getActiveSheet()->setTitle(&＃39;订单汇总表&＃39;); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); // Redirect output to a client&＃39;s web browser (Excel5)
ob_end_clean();//清除缓冲区,避免乱码 header(&＃39;Content-Type: application/vnd.ms-excel&＃39;); header(&＃39;Content-Disposition: attachment;filename="订单汇总表(&＃39; . date(&＃39;Ymd-His&＃39;) . &＃39;).xls"&＃39;); header(&＃39;Cache-Control: max-age=0&＃39;); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, &＃39;Excel5&＃39;); $objWriter->save(&＃39;php://output&＃39;); ?>
在header() 前面加上ob_end_clean() 函数，清除缓冲区, 这样就不会乱码了!
以上就是php 导出excel 乱码怎么办的详细内容，
觉得文章有用就打赏一下文章作者
微信扫一扫打赏
