Layui和TP5导入Excel单表
1、layui导入,导出,下载样式
<button class="layui-btn" onclick="exportData();">导出</button>
<button class="layui-btn" onclick="downloadTemplate();">模板下载</button>
<button id="importData" class="layui-btn" onclick="importData()">导入</button>
2、js部分
//导入 用layui upload插件layui.use([ "element", "laypage", "layer", "upload"], function() {
var element = layui.element;
var laypage = layui.laypage;
var layer = layui.layer;
var upload = layui.upload;//主要是这个
layui.upload.render({
elem: "#importData",//导入id
url: "{:url('uploadFile'}",
size: '3072',
accept: "file",
exts: 'xls|xlsx|xlsm|xlt|xltx|xltm',
done: function (result) {
layer.msg(result.msg);
widow.location.reload();
}
}
});
//refreshTable()
});
//导出
function exportData() {
$.ajax({
type: "post", url: "/xx/exportData", data: {}, success: function (result) {
if (result.status == 0) {
window.open(result.data)
}
if (result.message != null) {
layer.msg(result.message)
}
}, error: function (XMLHttpRequest, textStatus, errorThrown) {
layer.msg('{"status":"' + XMLHttpRequest.status + '","readyState":"' + XMLHttpRequest.readyState + '","textStatus":"' + textStatus + '","errorThrown":"' + errorThrown + '"}')
}
})
};
//模板下载
function downloadTemplate() {
$.ajax({
type: "post", url: "/xx/downloadTemplate", data: {}, success: function (result) {
if (result.status == 0) {
window.open(result.data)
}
if (result.message != null) {
layer.msg(result.message)
}
}, error: function (XMLHttpRequest, textStatus, errorThrown) {
layer.msg('{"status":"' + XMLHttpRequest.status + '","readyState":"' + XMLHttpRequest.readyState + '","textStatus":"' + textStatus + '","errorThrown":"' + errorThrown + '"}')
}
})
}
3、控制器部分
首先下载phpexcel
PHPExcel 扩展包下载地址: https://github.com/PHPOffice/PHPExcel
下载压缩包只需要解压后classes文件夹里的所有内容。
将其放在一个你自定义名字的文件夹里面,本人用的是PHPExcel,然后将文件夹放在extend里面,其余看代码
//导入
public function uploadFile()
{
// 引入核心文件
require'../extend/PHPExcel/PHPExcel.php';
header("content-type:text/html;charset=utf-8");
//上传excel文件
$file = request()->file('file');
$files = $_FILES['file'];
//将文件保存到public/uploads目录下面
$info = $file->