完美解决phpexcel导出到xls文件出现乱码的问题
解决方法如下所示：
<?php
include'global.php';
$ids=$_GET['ids'];
$sql="select*fromcrm_cost_endwhereidin({$ids})";
$result=$db->findAll($sql);
//echo$result[1]['sn'];
//创建一个excel对象
$objPHPExcel=newPHPExcel();
//Setproperties
$objPHPExcel->getProperties()->setCreator("ctos")
->setLastModifiedBy("ctos")
->setTitle("Office2007XLSXTestDocument")
->setSubject("Office2007XLSXTestDocument")
->setDescription("TestdocumentforOffice2007XLSX,generatedusingPHPclasses.")
->setKeywords("office2007openxmlphp")
->setCategory("Testresultfile");
//setwidth
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(8);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(50);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(30);
//设置行高度
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(22);
$objPHPExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
//setfontsizebold
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//设置水平居中
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
//
$objPHPExcel->getActiveSheet()->mergeCells('A1:J1');
//settableheadercontent
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1','订单数据汇总时间:'.date('Y-m-dH:i:s'))
->setCellValue('A2','订单ID')
->setCellValue('B2','下单人')
->setCellValue('C2','客户名称')
->setCellValue('D2','下单时间')
->setCellValue('E2','需求机型')
->setCellValue('F2','需求数量')
->setCellValue('G2','需求交期')
->setCellValue('H2','确认BOM料号')
->setCellValue('I2','PMC确认交期')
->setCellValue('J2','PMC交货备注');
//Miscellaneousglyphs,UTF-8
for($i=0;$i<count($result)-1;$i++){
$objPHPExcel->getActiveSheet(0)->setCellValue('A'.($i+3),$result[$i]['id']);
$objPHPExcel->getActiveSheet(0)->setCellValue('B'.($i+3),$result[$i]['realname']);
$objPHPExcel->getActiveSheet(0)->setCellValue('C'.($i+3),$result[$i]['customer_name']);
$objPHPExcel->getActiveSheet(0)->setCellValue('D'.($i+3),$OrdersData[$i]['create_time']);
$objPHPExcel->getActiveSheet(0)->setCellValue('E'.($i+3),$result[$i]['require_product']);
$objPHPExcel->getActiveSheet(0)->setCellValue('F'.($i+3),$result[$i]['require_count']);
$objPHPExcel->getActiveSheet(0)->setCellValue('G'.($i+3),$result[$i]['require_time']);
$objPHPExcel->getActiveSheet(0)->setCellValue('H'.($i+3),$result[$i]['product_bom_encoding']);
$objPHPExcel->getActiveSheet(0)->setCellValue('I'.($i+3),$result[$i]['delivery_time']);
$objPHPExcel->getActiveSheet(0)->setCellValue('J'.($i+3),$result[$i]['delivery_memo']);
$objPHPExcel->getActiveSheet()->getStyle('A'.($i+3).':J'.($i+3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A'.($i+3).':J'.($i+3))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getRowDimension($i+3)->setRowHeight(16);
}
//Renamesheet
$objPHPExcel->getActiveSheet()->setTitle('订单汇总表');
//Setactivesheetindextothefirstsheet,soExcelopensthisasthefirstsheet
$objPHPExcel->setActiveSheetIndex(0);
//Redirectoutputtoaclient'swebbrowser(Excel5)
<spanstyle="color:#ff0000;">ob_end_clean();//清除缓冲区,避免乱码</span>
header('Content-Type:application/vnd.ms-excel');
header('Content-Disposition:attachment;filename="订单汇总表('.date('Ymd-His').').xls"');
header('Cache-Control:max-age=0');
$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');
$objWriter->save('php://output');
?>
在header()前面加上ob_end_clean()函数，清除缓冲区,这样就不会乱码了!
以上就是小编为大家带来的完美解决phpexcel导出到xls文件出现乱码的问题全部内容了，希望大家多多支持毛票票~