最近在写基于larval框架的数据导出，然后用以前的方法写的时候发现，数据只能输出到浏览器，然后无法下载。然后用到了layUI框架自身的导出功能。
所以做个笔记。

<xblock><button class="layui-btn layui-btn-danger" onclick="delAll()"><i class="layui-icon">&#xe640;</i>批量删除</button><button class="layui-btn" onclick="store()"><i class="layui-icon download">&#xe654;</i>添加</button>//导出数据<button class="layui-btn layui-btn-warm" onclick="exportTable()"><i class="layui-icon download"></i>导出当前会员数据</button><button class="layui-btn layui-btn-danger" onclick="alldataTable()"><i class="layui-icon download"></i>导出所有会员数据</button>
</xblock>
<table class="layui-table x-admin layui-form" id="LAY-EXPORT-TEST"><colgroup><col width="150"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col width="200"><col></colgroup><thead><tr><th><div class="layui-unselect header layui-form-checkbox" lay-skin="primary"><i class="layui-icon">&#xe605;</i></div></th><th>推荐号</th><th>账号</th><th>用户级别</th><th>姓名</th><th>银行卡号</th><th>开户行</th><th>手机</th><th>积分</th><th>余额</th><th>冻结</th><th>抽奖券</th><th>推荐人</th><th>下线统计</th><th>操作</th></tr></thead><tbody id="view"></tbody></table>

<script id="demo" type="text/html"><%#  layui.each(d.data, function(index, item){ %><tr><td><% item.id %><div class="layui-unselect layui-form-checkbox" lay-skin="primary" data-id='<% item.id %>'><i class="layui-icon">&#xe605;</i></div></td><td ><% item.invicode?item.invicode:'' %></td><td class="title_<% item.id %>"><% item.username %></td><td><% item.levelName %></td><td><% item.realname?item.realname:'' %></td><td><% item.bankcode?item.bankcode:'' %></td><td><% item.bankaddress?item.bankaddress:'' %></td><td><% item.Showmobile?item.Showmobile:'' %></td><td><% item.integral?item.integral:'0' %></td><td><% item.amount?item.amount:'0' %></td><td><% item.is_dongjie %></td><td><% item.luckdraws %></td><td><% item.inviter?item.inviter:'' %><% item.inviterName?' | '+item.inviterName:'' %></td><td>推广人数:<% item.tuiguangrens %><br/>充值总额:<span style="color: #00a91c"><% item.recharges %></span><br/>提现总额:<span style="color: #ff19ee"><% item.withdrawals %></span><br/><%# if(item.moneys>0){ %>收益总额:<span style="color: #09ff09"><% item.moneys %></span><%# }else{%>收益总额:<span style="color: #ff0000"><% item.moneys %></span><%# } %></td><td class="td-manage" style="width:200px;"><a onclick="member_stop(this,<% item.id %>,<% d.current_page %>)" href="javascript:;"  title="<% item.state==0?'启用':'禁用' %>"><%# if(item.state==1){ %><i class="layui-icon" style="color:green;">&#xe62f;</i><%# }else{%><i class="layui-icon" style="color:red;">&#xe601;</i><%# } %></a><a title="查看密码"  onclick="showpassword('<% item.Showpassword %>','<% item.Showpaypwd %>')" href="javascript:;"><i class="layui-icon" style="color:red;">&#xe615;</i></a><a title="资金操作"  onclick="moneys(<% item.id %>,<% d.current_page %>)" href="javascript:;"><i class="layui-icon" style="color:green;">&#xe65e;</i></a><a title="冻结解冻"  onclick="frozen(<% item.id %>,<% d.current_page %>)" href="javascript:;"><i class="layui-icon" style="color: red;">&#xe659;</i></a><a title="赠送抽奖券"  onclick="luckdraws(<% item.id %>,<% d.current_page %>)" href="javascript:;"><i class="layui-icon" style="color: red;">&#xe66e;</i></a><a title="编辑"  onclick="update(<% item.id %>,<% d.current_page %>)" href="javascript:;"><i class="layui-icon" >&#xe642;</i></a><a title="删除" onclick="del(<% item.id %>,<% d.current_page %>)" href="javascript:;"><i class="layui-icon">&#xe640;</i></a></td></tr><%#  }); %><%#  if(d.length === 0){ %>无数据<%#  } %></script>

导出数据的Js

<script>
//后台导出所有数据function alldataTable() {var exportData = [];$.get("{{ route($RouteController.".csvout")}}", function (res) {if (res.code == 0) {exportData.push.apply(exportData, res.head);exportData.push.apply(exportData, res.data);LAY_EXCEL.exportExcel(exportData, '会员列表.xlsx', 'xlsx')}});}//导出当前页面（包括条件查询）function exportTable() {// 获取头部和bodyvar data = LAY_EXCEL.tableToJson(document.getElementById('LAY-EXPORT-TEST'));var exportData = [];exportData.push.apply(exportData, data.head);exportData.push.apply(exportData, data.body);LAY_EXCEL.exportExcel(exportData, '会员列表.xlsx', 'xlsx')}
</script>

导出全部数据，后台方法【主要是表头数据格式的传输】

public function csvout(Request $request){$list           = DB::table('member')->get()->toArray();$cellvalue = [];foreach ($list as $key => $item){$cellvalue[$key]['id']          = $item->id;$cellvalue[$key]['invicode']    = $item->invicode;$cellvalue[$key]['username']    = $item->username;$cellvalue[$key]['realname']    = $item->realname;$cellvalue[$key]['bankcode']    = $item->bankcode;$cellvalue[$key]['bankaddress'] = $item->bankaddress;$cellvalue[$key]['mobile']      = $item->mobile;$cellvalue[$key]['integral']    = $item->integral;$cellvalue[$key]['amount']      = $item->amount;}$head[] = ['id'          => 'ID','invicode'    => '推荐号','username'    => '账号','realname'    => '姓名','bankcode'    => '银行卡号','bankaddress' => '开户行','mobile'      => '手机','integral'    => '积分','amount'      => '余额'];return ["code"=>0,"data"=>$cellvalue,'head'=>$head];}