PHPEXCEl 在thinkphp的应用

导出执行函数

function exportExcel($data,$title,$headArr){
        //导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
        import("Org.Util.PHPExcel");
        import("Org.Util.PHPExcel.Writer.Excel5");
        import("Org.Util.PHPExcel.IOFactory.php");

        $date = date("Y_m_d_H_i_s",time());
        $title .= "_{$date}.xls";

        //创建PHPExcel对象，注意，不能少了\
        $objPHPExcel = new \PHPExcel();
        $objProps = $objPHPExcel->getProperties();

        //设置表头
        $key = ord("A");
        foreach($headArr as $v){
            $colum = chr($key);
//          $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.'1', $v);
            $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.'1', $v);
            $key += 1;
        }

        $column = 2;
        $objActSheet = $objPHPExcel->getActiveSheet();
        //合并单元格
        //$objPHPExcel->getActiveSheet()->mergeCells('A18:E22');
        //设置单元格的宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
//      $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
//      $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
//      $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
//      $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20);
//       $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);
        //print_r($data);exit;
        foreach($data as $key => $rows){ //行写入
            $span = ord("A");
            foreach($rows as $keyName=>$value){// 列写入
                $j = chr($span);
                $objActSheet->setCellValue($j.$column, ' '.$value);
                $span++;
            }
            $column++;
        }

        $title = iconv("utf-8", "gb2312", $title);
        //重命名表
        //$objPHPExcel->getActiveSheet()->setTitle('test');
        //设置活动单指数到第一个表,所以Excel打开这是第一个表
        $objPHPExcel->setActiveSheetIndex(0);
        header('Content-Type: application/vnd.ms-excel');
        header("Content-Disposition: attachment;filename=\"$title\"");
        header('Cache-Control: max-age=0');

        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $objWriter->save('php://output'); //文件通过浏览器下载
        exit;
    }

Controller写法：

    public function excelExport() {
        $list=M('Stocks')->field('psi_products.barcode,psi_products.title,psi_products.unit,psi_products.pricebuy,psi_products.pricesell,psi_products.tax,psi_stocks.stocks')->join('JOIN psi_products on psi_products.title = psi_stocks.product ')->select();
        $title = array('条形码', '商品名称', '单位','采购价','销售价','是否纳税(0:Y;1:N)','库存数量'); //设置要导出excel的表头
        exportExcel($list, '存库统计表', $title);
    }

模板里只要调用excelExport操作即可。