Thinkphp5.0 excel表格导出方法

//按行业导出信息
public function daochu_word(){
//判断状态 是否登录
$check_status=$this->status;
if($check_status != 200){
$msg=$this->msg;
if($check_status!=0){
$check_status=2;
}else{
$check_status=0;
}
return json(['status'=>$check_status,'msg'=>$msg,'info'=>'']);
}
$data=$this->data;
$name=Db::name('enterprise_type')->where('id',$data['id'])->value('title');
$header=['序号','隐患大类','隐患类型','隐患词条','法规依据','法规原文','隐患级别','快捷描述1','快捷描述2','快捷描述3','快捷描述4','快捷描述5','快捷描述6'];
$info=Db::view('course_ptype','title as course_ptype')
->view('course_type','title as course_type','course_type.ptype=course_ptype.id')
->view('course','id,title as course,brief,introduction,level','course.course_type=course_type.id')
->where('course_type.type',$data['id'])
->select();
foreach($info as $kk=>&$vv){
$vv['course_detail']=Db::name('course_detail')->field('id,title')->where('course_id',$vv['id'])->select();
if($vv['level']==1){
$vv['level']='低级';
}elseif($vv['level']==2){
$vv['level']='中级';
}else{
$vv['level']='高级';
}
}
foreach($info as $k=>$v){
$newdata[$k]['id']=($k+1);
$newdata[$k]['course_ptype']=$v['course_ptype'];
$newdata[$k]['course_type']=$v['course_type'];
$newdata[$k]['course']=$v['course'];
$newdata[$k]['brief']=$v['brief'];
$newdata[$k]['introduction']=$v['introduction'];
$newdata[$k]['level']=$v['level'];
if(!empty($v['course_detail'][0])){
$newdata[$k]['title1']=$v['course_detail'][0]['title'];
}else{
$newdata[$k]['title1']='';
}
if(!empty($v['course_detail'][1])){
$newdata[$k]['title2']=$v['course_detail'][1]['title'];
}else{
$newdata[$k]['title2']='';
}
if(!empty($v['course_detail'][2])){
$newdata[$k]['title3']=$v['course_detail'][2]['title'];
}else{
$newdata[$k]['title3']='';
}
if(!empty($v['course_detail'][3])){
$newdata[$k]['title4']=$v['course_detail'][3]['title'];
}else{
$newdata[$k]['title4']='';
}
if(!empty($v['course_detail'][4])){
$newdata[$k]['title5']=$v['course_detail'][4]['title'];
}else{
$newdata[$k]['title5']='';
}
if(!empty($v['course_detail'][5])){
$newdata[$k]['title6']=$v['course_detail'][5]['title'];
}else{
$newdata[$k]['title6']='';
}

};
$this->excelExport($name,$header,$newdata);
}

/**
* excel表格导出方法
* @param string $fileName 文件名称
* @param array $headArr 表头名称
* @param array $data 要导出的数据
* @author static7 */

function excelExport($fileName = '', $headArr = [], $data = []) {

$fileName .= "_" . date("Y_m_d",time()) . ".xls";

//调用插件
vendor('PHPExcel');
vendor('PHPExcel.IOFactory');
vendor('PHPExcel.Reader.Excel5');

$objPHPExcel = new \PHPExcel();

$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();

foreach ($data as $key => $rows) { // 行写入

$span = ord("A");

foreach ($rows as $keyName => $value) { // 列写入

$objActSheet->setCellValue(chr($span) . $column, $value);

$span++;

}

$column++;

}

$fileName = iconv("utf-8", "gb2312", $fileName); // 重命名表

$objPHPExcel->setActiveSheetIndex(0); // 设置活动单指数到第一个表,所以Excel打开这是第一个表

header('Content-Type: application/vnd.ms-excel');

header("Content-Disposition: attachment;filename=$fileName");

header('Cache-Control: max-age=0');

$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save('php://output'); // 文件通过浏览器下载

exit();

}