thinkphp5 导出excel

链接: https://pan.baidu.com/s/1sm7pcCiuDgYIUKeJMHRWKg 提取码: bcis 

public function expExcel()  
{  
    vendor("PHPExcel.PHPExcel");  
    $list=db('member')->field('*')->select();  
    $objPHPExcel = new \PHPExcel();
    $objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
    //设置sheet名称
    $sheets=$objPHPExcel->getActiveSheet()->setTitle('demo');
    //设置sheet列头信息
    $objPHPExcel->setActiveSheetIndex()->setCellValue('A1', 'id')->setCellValue('B1', 'name')->setCellValue('C1', 'image');
    $i=2;
    foreach($list as $v){
        //设置单元格的值
        $sheets=$objPHPExcel->getActiveSheet()->setCellValue('A'.$i,$v['id']);
        $sheets=$objPHPExcel->getActiveSheet()->setCellValue('B'.$i,$v['name']);
        $sheets=$objPHPExcel->getActiveSheet()->setCellValue('C'.$i,$v['image']);
        $i++;
    }
    //整体设置字体和字体大小
    $objPHPExcel->getDefaultStyle()->getFont()->setName( 'Arial');
    $objPHPExcel->getDefaultStyle()->getFont()->setSize(10);
    // $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); //单元格宽度自适应
    $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20); //设置列宽度
    $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20); //设置列宽度
    $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20); //设置列宽度
    $objPHPExcel->getActiveSheet()->getStyle('B3')->getFont()->setBold(true); //设置单元格字体加粗
    // 输出Excel表格到浏览器下载
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="demo.xls"'); //excel表格名称
    $objWriter->save('php://output');     // 下载文件

    

    // $objWriter->save('./public/export/test.xls');        // 保存到你指定的路径中

}

转载于:https://my.oschina.net/u/3853452/blog/2907095