import { dayjs } from "element-plus";
|
// import XLSX from "xlsx"; //导入xlsx
|
|
export const baseUrl = "http://192.168.1.103:9093"
|
// http://192.168.0.80:1598
|
// http://192.168.1.103:9093 以前线上地址
|
|
|
//对象转FormData生成方法
|
export function objToFormData(obj) {
|
let formData = new FormData();
|
for (let key in obj) {
|
formData.append(key, obj[key]);
|
}
|
return formData;
|
}
|
|
//时间转换为YYYY-MM-DD HH:mm:ss格式,使用dayjs
|
export function formatTime(time) {
|
if (time) {
|
return dayjs(time).format("YYYY-MM-DD HH:mm:ss");
|
} else {
|
return "";
|
}
|
}
|
|
export function exportExcel(json, name, titleArr, sheetName) {
|
/* convert state to workbook */
|
var data = new Array();
|
var keyArray = new Array();
|
const getLength = function (obj) {
|
var count = 0;
|
for (var i in obj) {
|
if (obj.hasOwnProperty(i)) {
|
count++;
|
}
|
}
|
return count;
|
};
|
for (const key1 in json) {
|
if (json.hasOwnProperty(key1)) {
|
const element = json[key1];
|
var rowDataArray = new Array();
|
for (const key2 in element) {
|
if (element.hasOwnProperty(key2)) {
|
const element2 = element[key2];
|
rowDataArray.push(element2);
|
if (keyArray.length < getLength(element)) {
|
keyArray.push(key2);
|
}
|
}
|
}
|
data.push(rowDataArray);
|
}
|
}
|
// keyArray为英文字段表头
|
data.splice(0, 0, keyArray, titleArr);
|
const ws = XLSX.utils.aoa_to_sheet(data);
|
const wb = XLSX.utils.book_new();
|
// 此处隐藏英文字段表头
|
var wsrows = [{ hidden: true }];
|
ws['!rows'] = wsrows; // ws - worksheet
|
XLSX.utils.book_append_sheet(wb, ws, sheetName);
|
/* generate file and send to client */
|
XLSX.writeFile(wb, name + '.xlsx');
|
}
|
