layui.table.exportFile 导出数据并清除单元格中的空格

Layui在执行数据导出的时候，会出现部分数据单元格中有空格的情况,下面的方法可以去除掉单元格中的空格,供大家参考！！

function table_export(id,title) {//根据传入tableID获取表头var headers = $("div[lay-id=" + id + "] .layui-table-box table").get(0);var htrs = Array.from(headers.querySelectorAll('tr'));var titles = {};for (var j = 0; j < htrs.length; j++) {var hths = Array.from(htrs[j].querySelectorAll("th"));for (var i = 0; i < hths.length; i++) {var clazz = hths[i].getAttributeNode('class').value;if (clazz != ' layui-table-col-special' && clazz != 'layui-hide') {//排除居左、具有、隐藏字段//修改:默认字段data-field+i,兼容部分数据表格中不存在data-field值的问题titles['data-field' + i] = hths[i].innerText;}}}//根据传入tableID获取table内容var bodys = $("div[lay-id=" + id + "] .layui-table-box table").get(1);var btrs = Array.from(bodys.querySelectorAll("tr"))var bodysArr = new Array();for (var j = 0; j < btrs.length; j++) {var contents = {};var btds = Array.from(btrs[j].querySelectorAll("td"));for (var i = 0; i < btds.length; i++) {for (var key in titles) {//修改:默认字段data-field+i,兼容部分数据表格中不存在data-field值的问题var field = 'data-field' + i;if (field === key) {//根据表头字段获取table内容字段contents[field] = btds[i].innerText;}}}bodysArr.push(contents)}//将标题行置顶添加到数组bodysArr.unshift(titles);if(bodysArr.length > 0){LAY_EXCEL.exportExcel(bodysArr, title +new Date().toLocaleString()+'.xlsx', 'xlsx');} else {layer.msg("请选择需要导出的数据！");}
}