Angular 导出CSV表

emmmmmmmmmmmmmmm 代码如下 简单的CSV能直接拿来用

import {Injectable} from '@angular/core';
@Injectable()
export class ExportService {
csvSeparator = ',';
constructor() {
}
/**
* @param value //[{'姓名':'小明','成绩','100'}]
* @param columns //['姓名','成绩']
* @param exportFilename // '成绩统计表'
*/
exportCSV(value, columns, exportFilename) {
const data = value;
let csv = 'ufeff';
// headers
for (let i = 0; i < columns.length; i++) {
const column = columns[i];
csv += '"' + (column.header || column) + '"';
if (i < (columns.length - 1)) {
csv += this.csvSeparator;
}
}
// body
data.forEach((record) => {
csv += 'n';
for (let i_1 = 0; i_1 < columns.length; i_1++) {
const column = columns[i_1];
csv += '"' + this.resolveFieldData(record, column) + '"';
if (i_1 < (columns.length - 1)) {
csv += this.csvSeparator;
}
}
});
const blob = new Blob([csv], {
type: 'text/csv;charset=utf-8;'
});
if (window.navigator.msSaveOrOpenBlob) {
navigator.msSaveOrOpenBlob(blob, exportFilename + '.csv');
} else {
const link = document.createElement('a');
link.style.display = 'none';
document.body.appendChild(link);
if (link.download !== undefined) {
link.setAttribute('href', URL.createObjectURL(blob));
link.setAttribute('download', exportFilename + '.csv');
link.click();
} else {
csv = 'data:text/csv;charset=utf-8,' + csv;
window.open(encodeURI(csv));
}
document.body.removeChild(link);
}
}
resolveFieldData(data, field) {
if (data && field) {
if (field.indexOf('.') === -1) {
return data[field];
} else {
const fields = field.split('.');
let value = data;
for (let i = 0, len = fields.length; i < len; ++i) {
if (value === null) {
return null;
}
value = value[fields[i]];
}
return value;
}
} else {
return null;
}
}
}

最后

以上就是高大鸭子为你收集整理的Angular 导出CSV表的全部内容，希望文章能够帮你解决Angular 导出CSV表所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。