ThinkPHP3.2 数据导出为Excel

背景：将数据导出为Excel表

控制器代码：

public function excel(){
        $xlsName  = "答题记录表";
        $xlsCell  = array(
            array('stitle','题干'),
            array('nickname','微信名称'),
            array('str_q','答题内容'),
            array('uptime','答题时间'),
        );
        $xlsModel = M('records');
        $xlsData  = M("records")
            ->join("stems on stems.id = records.sid")
            ->join("user on user.openid = records.openid")
            ->field("records.*,stems.stitle,user.nickname")
            ->order("records.id desc")
            ->select();
        
        exportExcel($xlsName,$xlsCell,$xlsData);
    }

 

function.php 放到common目录下

<?php
/**
 * Created by PhpStorm