1、乱码截图
我是用的Ajax请求,附上解决办法:
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . $name . '.xlsx"');
header('Cache-Control: max-age=0');
$writer = new Xlsx($spreadsheet);
ob_start(); //打开缓冲区
$writer->save('php://output'); //这里就是乱码
// 接收并处理
$xlsData = ob_get_contents();
ob_end_clean(); // 清除缓冲
$response = array(
'code' => '1',
'file' => "data:application/vnd.ms-excel;base64,".base64_encode($xlsData),
'msg'=>'导出成功'
);
return json_encode($response);
附上全部代码:
1、html部分:
<div class="center mb10">
<form class="layui-form " method="post">
<div class="layui-input-inline w150">
<select name="status" id="sel">
<option value="">选择状态</option>
<option value="0" {if condition="$param['status'] eq '0'"}selected {/if}>未审核</option>
<option value="1" {if condition="$param['status'] eq '1'"}selected {/if}>已审核</option>
</select>
</div>
<div class="layui-input-inline w150">
<select name="group