下载Blod文件(导出处理文件流)
export function exportExcelBlod(data,fileName){
if(!data) {
return;
};
const name = fileName || `${formatDataTime('yyyyMMDDHHmmss')}.xlsx`;
const blob = new Blob([data], {
type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;'
});
const href = window.URL.createObjectURL(blob);
const downloadElement = document.createElement('a')
downloadElement.style.display = 'none';
downloadElement.href = href;
downloadElement.download = name;
document.body.appendChild(downloadElement);
const evt = document.createEvent("MouseEvents");
evt.initEvent("click", true, true);
downloadElement.dispatchEvent(evt);
document.body.removeChild(downloadElement);
window.URL.revokeObjectURL(blobUrl);
}
export function formatDataTime(formatStr, date){
formatStr = arguments[0] || "yyyy-MM-dd HH:mm:ss";
date = arguments[1] || new Date();
var str = formatStr;
var Week = ['日','一','二','三','四','五','六'];
str=str.replace(/yyyy|YYYY/,date.getFullYear());
str=str.replace(/yy|YY/,(date.getYear() % 100)>9?(date.getYear() % 100).toString():'0' + (date.getYear() % 100));
str=str.replace(/MM/,date.getMonth()>9?(date.getMonth() + 1):'0' + (date.getMonth() + 1));
str=str.replace(/M/g,date.getMonth());
str=str.replace(/w|W/g,Week[date.getDay()]);
str=str.replace(/dd|DD/,date.getDate()>9?date.getDate().toString():'0' + date.getDate());
str=str.replace(/d|D/g,date.getDate());
str=str.replace(/hh|HH/,date.getHours()>9?date.getHours().toString():'0' + date.getHours());
str=str.replace(/h|H/g,date.getHours());
str=str.replace(/mm/,date.getMinutes()>9?date.getMinutes().toString():'0' + date.getMinutes());
str=str.replace(/m/g,date.getMinutes());
str=str.replace(/ss|SS/,date.getSeconds()>9?date.getSeconds().toString():'0' + date.getSeconds());
str=str.replace(/s|S/g,date.getSeconds());
return str;
}