使用thinkphp5對excel檔案進行匯出

// 应用公共文件 /** * 导出excel * @param $strTable 表格内容 * @param $filename 文件名 */ function downloadExcel($strTable, $filename) { header("Content-type: application/vnd.ms-excel"); header("Content-Type: application/force-download"); header("Content-Disposition: attachment; filename=" . $filename . "_" . date('Y-m-d') . ".xls"); header('Expires:0'); header('Pragma:public'); echo '' . $strTable . ''; }

public function excel_daochu(){ $strTable =''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $aa = db("user")->select(); foreach ($aa as $k => &$v) { $v['add_time'] = date('Y-m-d H:i:s',$v['add_time']); } foreach($aa as $k=>$val){ $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; $strTable .= ''; } $strTable .='
ID
用户账号
昵称
时间
'.$val['user_id'].'
'.$val['tel'].'
'.$val['ni_name'].' 
'.$val['add_time'].'
'; downloadExcel($strTable,'用户列表'); exit(); }