thinkphp+phpexcel导出带图片的表格

PHPExcel下载地址 https://github.com/PHPOffice/PHPExcel

将下载下来PHPExcel中的Classes里的文件复制到项目里（这个博主放到了vender目录中并重新起名PHPExcel）


直接上代码

//前端博主这里使用的是layui
,doexcel:function () {
   
    var checkStatus = table.checkStatus('LAY-user-manage')
        ,checkData = checkStatus.data; //得到选中的数据
    if(checkData.length === 0){
   
        return layer.msg('请选择数据');
    }
    var ids = '';
    for (var i = 0;i<checkData.length;i++){
   
        ids += checkData[i].id+',';
    }
    layer.confirm('确定导出吗？', function(index) {
   
        var url = "";   //请求地址
        url += '?ids='+ids;
        window.location.href = url;
        layer.close(index);
    });
}

后台代码

		$param = $this->request->param();
        $ids = explode(',',$param['ids']);
        vendor("PHPExcel.PHPExcel");
        $objPHPExcel = new \PHPExcel();

        //水平居中
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment