背景:将数据导出为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")
-&g