本文主要講解關(guān)于PHPExcel兼容PHP版本和操作execl知識

• 目前解決問題：兼容PHP版本問題。

闡述下：小伙子我改bug的過程，如下：線下將代碼寫好（無錯誤），本地Apache服務(wù)器測試-->正常，打開導(dǎo)出的execl文件中數(shù)據(jù)也正常;到服務(wù)器上就會報找不到該文件錯誤，如圖：

火狐瀏覽器，谷歌瀏覽器是直接說該文件已遷移什么的

• 歷程：重新審查代碼，定位到$objWriter->save('php://output')這行出問題，萬般無奈看插件源碼,找來找去發(fā)現(xiàn)save方法返回的對象并沒有問題!接著去找百度，說是php.ini中的extension=php_zip模塊沒有開啟，進入conf文件，Windows下面編譯好的PHP5.6.31并沒有這個配置;沒辦法了，只剩下最后一個必殺技了(看文檔)：查找PHPExcel官方文檔，發(fā)現(xiàn)是PHPExcel兼容PHP版本問題，線上的PHP7.0，本地的5.6.31；好了，按照官方說法將PHPExcel插件替換成1.8.1的，再次測試，nice，so beautiful.解決問題
• 下面是頭部關(guān)鍵代碼:

        //輸出EXCEL格式
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        // 從瀏覽器直接輸出$filename
        header('Content-Type:application/csv;charset=UTF-8');
        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-excel;");
        header("Content-Type:application/octet-stream");
        header('Content-Disposition: attachment;filename="'.$name.'.xls"');
        header("Content-Transfer-Encoding:binary");
        $objWriter->save('php://output');

• 操作execl知識(設(shè)置Excel基本樣式信息):

        $objPHPExcel = new \PHPExcel();
        // 設(shè)置excel文檔的屬性
        $objPHPExcel->getProperties()->setCreator("WSTMart")//創(chuàng)建人
        ->setLastModifiedBy("WSTMart")//最后修改人
        ->setTitle($name)//標題
        ->setSubject($name)//題目
        ->setDescription($name)//描述
        ->setKeywords("訂單")//關(guān)鍵字
        ->setCategory("Test result file");//種類
    
        // 開始操作excel表
        $objPHPExcel->setActiveSheetIndex(0);
        // 設(shè)置工作薄名稱
        $objPHPExcel->getActiveSheet()->setTitle(iconv('gbk', 'utf-8', 'Sheet'));
        // 設(shè)置默認字體和大小
        $objPHPExcel->getDefaultStyle()->getFont()->setName(iconv('gbk', 'utf-8', ''));
        $objPHPExcel->getDefaultStyle()->getFont()->setSize(11);
        $styleArray = array(
                'font' => array(
                        'bold' => true,
                        'color'=>array(
                                'argb' => 'ffffffff',
                        )
                ),
                'borders' => array (
                        'outline' => array (
                                'style' => \PHPExcel_Style_Border::BORDER_THIN,  //設(shè)置border樣式
                                'color' => array ('argb' => 'FF000000'),     //設(shè)置border顏色
                        )
                )
        );
        //設(shè)置寬
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(12);
        $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(50);
        $objPHPExcel->getActiveSheet()->getStyle('A1:P1')->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
        $objPHPExcel->getActiveSheet()->getStyle('A1:P1')->getFill()->getStartColor()->setARGB('333399');
        
        $objPHPExcel->getActiveSheet()->setCellValue('A1', '訂單編號')->setCellValue('B1', '訂單狀態(tài)')->setCellValue('C1', '收貨人')->setCellValue('D1', '收貨地址')->setCellValue('E1', '聯(lián)系方式')
        ->setCellValue('F1', '支付方式')->setCellValue('G1', '配送方式')->setCellValue('H1', '買家留言')->setCellValue('I1', '發(fā)票信息')->setCellValue('J1', '訂單總金額')->setCellValue('K1', '運費')
        ->setCellValue('L1', '實付金額')->setCellValue('M1', '下單時間')->setCellValue('N1', '發(fā)貨時間')->setCellValue('O1', '收貨時間')->setCellValue('P1', '取消/拒收原因');
        $objPHPExcel->getActiveSheet()->getStyle('A1:P1')->applyFromArray($styleArray);

• Excel表格內(nèi)容填充

for ($row = 0; $row < count($page); $row++){
            $i = $row+2;
            $objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $page[$row]['orderNo'])->setCellValue('B'.$i, $page[$row]['status'])->setCellValue('C'.$i, $page[$row]['userName'])->setCellValue('D'.$i, $page[$row]['userAddress'])
            ->setCellValue('E'.$i, $page[$row]['userPhone'])->setCellValue('F'.$i, $page[$row]['payTypeName'])->setCellValue('G'.$i, $page[$row]['deliverType'])->setCellValue('H'.$i, $page[$row]['orderRemarks'])->setCellValue('I'.$i, $page[$row]['invoiceClient'])
            ->setCellValue('J'.$i, $page[$row]['totalMoney'])->setCellValue('K'.$i, $page[$row]['deliverMoney'])->setCellValue('L'.$i, $page[$row]['realTotalMoney'])->setCellValue('M'.$i, $page[$row]['createTime'])->setCellValue('N'.$i, $page[$row]['deliveryTime'])
            ->setCellValue('O'.$i, $page[$row]['receiveTime'])->setCellValue('P'.$i, $page[$row]['logContent']);
        }