thinkcmf thinkphp 使用phpExcel批量导出

之前做了个导入，结果今天打电话要一个导出的的
依然是通过composer安装phpoffice

在控制器里引入

use PHPExcel_IOFactory;
use PHPExcel;

然后就是正常的查询输出了

  //开始导出excel

      header("content-type:text/html; charset=utf-8");
  
        $objPHPExcel = new PHPExcel();
        // 操作第一个工作表
        $objPHPExcel->setActiveSheetIndex(0);


         
        error_reporting(E_ALL);
        date_default_timezone_set('Europe/London');
        $objPHPExcel = new PHPExcel();

        $name='这里是excel的名称'.date('Y-m-d_H_i_s',time());

   // 设置表格宽度
    $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(5);
    $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
    $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(50);
    $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(40);
    $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
    $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(40); 
 
    // 列名赋值
    $objPHPExcel->getActiveSheet()->setCellValue('A1', 'ID');
    $objPHPExcel->getActiveSheet()->setCellValue('B1', '出生时间');
    $objPHPExcel->getActiveSheet()->setCellValue('C1', '姓名');
    $objPHPExcel->getActiveSheet()->setCellValue('D1', '性别');
    $objPHPExcel->getActiveSheet()->setCellValue('E1', '住址');
    $objPHPExcel->getActiveSheet()->setCellValue('F1', '父母名称'); 
//excel格式问题，关于日期的需要单独设置下
$objPHPExcel->getActiveSheet()->getStyle('B')->getNumberFormat()->setFormatCode("YYYY/m/d  H:I");
     // 数据起始行
        $row_num = 2;
        // 向每行单元格插入数据
        foreach($court_list as $value)//要导出的数据源
        { 
     
            // 设置单元格数值
            $objPHPExcel->getActiveSheet()->setCellValue('A' . $row_num, $value['id']);
            $objPHPExcel->getActiveSheet()->setCellValue('B' . $row_num, date('Y-m-d  H:i:s',$value['open_time']) );
            $objPHPExcel->getActiveSheet()->setCellValue('C' . $row_num, $value['name'] );
            $objPHPExcel->getActiveSheet()->setCellValue('D' . $row_num, $value['sex']);
            $objPHPExcel->getActiveSheet()->setCellValue('E' . $row_num, $value['address_name']);
  
            $objPHPExcel->getActiveSheet()->setCellValue('F' . $row_num, $value['referee_name_arr']);
            $row_num++;
        }
      
    $objPHPExcel->getActiveSheet()->setTitle('User');
    $objPHPExcel->setActiveSheetIndex(0);
    header('Content-Type: applicationnd.ms-excel');
    header('Content-Disposition: attachment;filename="'.$name.'.xlsx"');
    header('Cache-Control: max-age=0');
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save('php://output');
    exit;