ThinkPHP用PHPExcle导出Excel文件

     
/**
* 数据导出为.xls格式
* @param string $fileName 导出的文件名
* @param $expCellName     array -> 数据库字段以及字段的注释
* @param $expTableData    Model -> 连接的数据库
*/
    public function exportExcel($fileName='table',$expCellName,$expTableData){
$xlsTitle = iconv('utf-8', 'gb2312', $fileName);//文件名称
$xlsName = $fileName.date("_Y.m.d_H.i.s"); //or $xlsTitle 文件名称可根据自己情况设定
$cellNum = count($expCellName);
$dataNum = count($expTableData);
import("Vendor.PHPExcel.PHPExcel");
import("Vendor.PHPExcel.Writer.Excel5");
import("Vendor.PHPExcel.IOFactory.php");
$objPHPExcel = new \PHPExcel();
$cellName = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE','AF','AG','AH','AI','AJ','AK','AL','AM','AN','AO','AP','AQ','AR','AS','AT','AU','AV','AW','AX','AY','AZ');
$objPHPExcel->getActiveSheet(0)->mergeCells('A1:'.$cellName[$cellNum-1].'1');//合并单元格
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $fileName.'  Export time:'.date('Y-m-d H:i:s'));
        for($i=0;$i<$cellNum;$i++){
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i].'2', $expCellName[$i][1]);
}
        // Miscellaneous glyphs, UTF-8
        for($i=0;$i<$dataNum;$i++){
            for($j=0;$j<$cellNum;$j++){
$objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j].($i+3), $expTableData[$i][$expCellName[$j][0]]);
}
}
header('pragma:public');
header('Content-type:application/vnd.ms-excel;charset=utf-8;name="'.$xlsTitle.'.xls"');
header("Content-Disposition:attachment;filename=$xlsName.xls");//attachment新窗口打印inline本窗口打印
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
        exit;
}

     
/**导出**/
   public function msgOut(){
$excel = A('Excel');
$xlsCell = array(
           array('id', 'ID'),
           array('staff_name', '昵称'),
           array('staff_real', '真实姓名'),
           array('mobile', '手机号'),
           array('card_id', '身份证号'),
           array('referee', '推荐人'),
           array('game_id', '游戏ID'),
           array('money', '余额'),
           array('consume_coin', '消费币'),
           array('create_time', '注册时间'),
           array('status', '状态'),
);
$xlsName = 'Staff表搜索结果导出';
$field = null;
       foreach ($xlsCell as $key => $value) {
           if($key == 0){
$field = $value[0];
}else{
$field .= "," . $value[0];
}
}
$xlsModel = M('Staff');
       if (IS_POST) {
$map = $this -> _queryTime();
$staff_name = I('staff_name');
           if($staff_name) {
               if (is_numeric($staff_name)) {
$map["id|staff_name"] = array(intval($staff_name), array('like', '%' . $staff_name . '%'), '_multi' => true);
} else {
$map['staff_name'] = array('like', '%' . (string)$staff_name . '%');
}
}
$xlsData = $xlsModel->Field($field)->where($map)->order('id DESC')->select();
}
       foreach ($xlsData as $k => $v) {
$xlsData[$k]['create_time'] = $v['create_time'] == null ? '-' : date("Y-m-d H:i",$v['create_time']);
$xlsData[$k]['status'] = $v['status'] == 1 ? '正常' : '禁用';
}
$excel->exportExcel($xlsName,$xlsCell,$xlsData);
}

     
<form action="{:U('Main/msgOut')}" method="post" class="form-horizontal">
    <div class="search-form fr cf">
        <div class="sleft">
            <input type="text" class="search-input" onClick="WdatePicker()" name="start_time" style="cursor: pointer;" value="{:I('start_time')}" id="start" placeholder="开始日期" />
            <input type="text" class="search-input" onClick="WdatePicker()" name="end_time" style="cursor: pointer;" value="{:I('end_time')}" id="end" placeholder="结束日期" />
            <input type="text" name="staff_name" class="search-input" value="{:I('staff_name')}" id="name" placeholder="输入推广专员的昵称或者ID">
            <button type="submit" class="btn" id="out">导出</button>
        </div>
    </div>
</form>