thinkphp3.2.3 整合phpExcel导出数据

不言

Lepaskan： 2023-03-23 16:32:02

asal

2947 orang telah melayarinya

这篇文章给大家分享的内容是关于thinkphp3.2.3 整合phpExcel导出数据，有需要的朋友可以参考一下

public function alliance_createxls(){  
        $allianceObj = M(&#39;alliance_apply&#39;);
        $result = $allianceObj
                  ->field("apply_name,sex,company,card,duty,phone,points_part,email,stayinfo,eatinfo,address,remark")
                  ->select();
        foreach ($result as $key => $vo) {
        	$result[$key][&#39;card&#39;] = $vo[&#39;card&#39;]." ";
        	$result[$key][&#39;phone&#39;] = $vo[&#39;phone&#39;]." ";
        	if($vo[&#39;sex&#39;] == 0){
                 $result[$key][&#39;sex&#39;] = &#39;男&#39;;  
        	}else{
        		 $result[$key][&#39;sex&#39;] = &#39;女&#39;;
        	}
        	switch ($vo[&#39;duty&#39;]) {
        		    case 1:
        			$result[$key][&#39;duty&#39;] = &#39;学校院长&#39;;
        			break;
        			case 2:
        			$result[$key][&#39;duty&#39;] = &#39;学校副院长&#39;;
        			break;
        			case 3:
        			$result[$key][&#39;duty&#39;] = &#39;分院院长&#39;;
        			break;
        			case 4:
        			$result[$key][&#39;duty&#39;] = &#39;分院副院长&#39;;
        			break;
        			case 5:
        			$result[$key][&#39;duty&#39;] = &#39;系主任&#39;;
        			break;
        			case 6:
        			$result[$key][&#39;duty&#39;] = &#39;副系主任&#39;;
        			break;
        			case 7:
        			$result[$key][&#39;duty&#39;] = &#39;教研室主任&#39;;
        			break;
        			case 8:
        			$result[$key][&#39;duty&#39;] = &#39;教师&#39;;
        			break;
        			case 9:
        			$result[$key][&#39;duty&#39;] = &#39;总经理&#39;;
        			break;
        			case 10:
        			$result[$key][&#39;duty&#39;] = &#39;副总经理&#39;;
        			break;
        			case 11:
        			$result[$key][&#39;duty&#39;] = &#39;总监&#39;;
        			break;
        			case 12:
        			$result[$key][&#39;duty&#39;] = &#39;职员&#39;;
        			break;
        		
        		default:
        			$result[$key][&#39;duty&#39;] = &#39;学校院长&#39;;
        			break;
        	}
        	switch ($vo[&#39;points_part&#39;]) {
        		    case 1:
        			    $result[$key][&#39;points_part&#39;] = &#39;信息安全校企合作分盟&#39;;
        			break;
        			case 2:
        			    $result[$key][&#39;points_part&#39;] = &#39;云计算校企合作分盟&#39;;
        			break;
        			case 3:
        			    $result[$key][&#39;points_part&#39;] = &#39;计算机网络校企合作分盟&#39;;
        			break;
        			case 4:
        			    $result[$key][&#39;points_part&#39;] = &#39;机器人技术应用校企合作分盟&#39;;
        			break;
        			case 5:
        			    $result[$key][&#39;points_part&#39;] = &#39;VR专业分盟&#39;;
        			break;       		
        		default:
        			$result[$key][&#39;points_part&#39;] = &#39;--&#39;;
        			break;
        	}
        	if($vo[&#39;stayinfo&#39;] == 1){
                    $result[$key][&#39;stayinfo&#39;] = &#39;单住&#39;;
        	}else{
                    $result[$key][&#39;stayinfo&#39;] = &#39;合住&#39;;
        	}
        }
 
	    //导入PHPExcel类库，因为PHPExcel没有用命名空间，只能inport导入
	    import("Org.Util.PHPExcel");
	    import("Org.Util.PHPExcel.Writer.Excel5");
	    import("Org.Util.PHPExcel.IOFactory.php");
	    $filename="联盟大会报名";
	    $headArr=array("姓名","性别","单位名称","身份证号","职务","手机号码","分盟参与意向","邮箱地址","住宿要求","饮食要求","通讯地址","备注信息");
	    $this->getExcel($filename,$headArr,$result);
	}
	private    function getExcel($fileName,$headArr,$data){
    //对数据进行检验
    if(empty($data) || !is_array($data)){
        die("data must be a array");
    }
    //检查文件名
    if(empty($fileName)){
        exit;
    }
    $date = date("Y_m_d_H_i_s",time());
    $fileName .= "_{$date}.xls";
    //创建PHPExcel对象，注意，不能少了\
    $objPHPExcel = new \PHPExcel();
    $objProps = $objPHPExcel->getProperties();


    //设置表头
    $key = ord("A");
    foreach($headArr as $v){
        $colum = chr($key);
        $objPHPExcel->setActiveSheetIndex(0) ->setCellValue($colum.&#39;1&#39;, $v);
        $key += 1;
    }
    $column = 2;
    $objActSheet = $objPHPExcel->getActiveSheet();
    foreach($data as $key => $rows){ //行写入
        $span = ord("A");
        foreach($rows as $keyName=>$value){// 列写入
            $j = chr($span);
            $objActSheet->setCellValue($j.$column, $value);
            $span++;
        }
        $column++;
    }
    $fileName = iconv("utf-8", "gb2312", $fileName);
    //重命名表
    // $objPHPExcel->getActiveSheet()->setTitle(&#39;test&#39;);
    //设置活动单指数到第一个表,所以Excel打开这是第一个表
    $objPHPExcel->setActiveSheetIndex(0);
    ob_end_clean();
    ob_start();
    header(&#39;Content-Type: application/vnd.ms-excel&#39;);
    header("Content-Disposition: attachment;filename=\"$fileName\"");
    header(&#39;Cache-Control: max-age=0&#39;);
    $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, &#39;Excel5&#39;);
    $objWriter->save(&#39;php://output&#39;); //文件通过浏览器下载
    exit;
}

Salin selepas log masuk

关于PHPExcel导出Excel时身份证,数字会导出为科学计数的处理方法

这是因为Excel处理数字里默认数字太长会转化为科学计数法，处理起来很简单，我们在导出时把数字转为字符串，Excel就不会识别为数字了，也就不会显示为科学计数方式。

我的处理方式是在变量后面加个空格，简单方便。

$usercode .=  &#39; &#39;;$money .= &#39; &#39;;

Salin selepas log masuk

Atas ialah kandungan terperinci thinkphp3.2.3 整合phpExcel导出数据. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!