layui php phpexcel导出,layui 导出excel

## :-: layui 导出excel

~~~

// 导出excel表

$('#export').on('click', function(){

const data = $("form").serializeArray()

let _parmas = {}

for (let i in data) {

_parmas[data[i].name] = data[i].value

}

let _exportConfig = {

url :'/export/goods/export',

parmas: _parmas,

fileName:'商品列表'

};

layer.confirm('确认导出吗?', function(index){

let exportIndex = layer.load(2)

let xhr = window.XMLHttpRequest ? new XMLHttpRequest() : new ActiveXObject("Microsoft.XMLHTTP");

xhr.open('post', _exportConfig.url, true);

//xhr.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');

xhr.setRequestHeader('Content-Type', 'application/json');

//xhr.setRequestHeader('ctrl', 'center_data');

xhr.responseType = 'blob';

xhr.onload = function(e) {

var blob = xhr.response;console.log(blob);

if (this.status == 200) {

if (blob && blob.size > 0) {

var blob = new Blob([xhr.response], {type: 'Files'});

var csvUrl = URL.createObjectURL(blob);

var link = document.createElement('a');

link.href = csvUrl;

link.download = _exportConfig.fileName+".xlsx";

link.click();

layer.close(exportIndex)

layer.msg('完成')

}

}

}

xhr.send(JSON.stringify(_exportConfig.parmas))

layer.close(index)

})

return false

})

~~~