phpexcel导出excel

一:引入phpoffice/phpexcel

use PHPExcel;
use PHPExcel_Reader_Excel5;

二:代码

protected function excel($filename, $data, $cost_total, $subtotal_total, $subtoals_total)
{
    $objPHPExcel = new PHPExcel();
    $objPHPExcel->getActiveSheet();//获取到sheet
    $objPHPExcel->getProperties()->setCreator("Damon");
    $objPHPExcel->getProperties()->setTitle("PI单统计列表");
    //set width
    $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
    $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
    $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(8);
    $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(10);
    $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
    $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);
    $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20);
    $objPHPExcel->getActiveSheet()->getColumnDimension('L')-&