完美解决phpexcel导出到xls文件出现乱码的问题

解决方法如下所示：

<?php
include "global.php";
$ids = $_GET["ids"];

$sql = "select * from crm_cost_end where id in ( {$ids} )";
$result = $db->findAll($sql);
//echo $result[1]["sn"];

//创建一个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("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);

//set font size bold 
$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");

// set table header content 
$objPHPExcel->setActiveSheetIndex(0)
    ->setCellValue("A1", "订单数据汇总 时间:" . date("Y-m-d H: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交货备注");

// Miscellaneous glyphs, 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);
}


// Rename sheet 
$objPHPExcel->getActiveSheet()->setTitle("订单汇总表");


// Set active sheet index to the first sheet, so Excel opens this as the first sheet 
$objPHPExcel->setActiveSheetIndex(0);


// Redirect output to a client"s web browser (Excel5) 
<span style="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文件出现乱码的问题全部内容了，希望大家多多支持网页设计~