我有一个名为csvdata
的字段,其中包含以下格式的数组:
[
[1,2,3],
[4,5,6],
[7,8,9]
]
我正在尝试下载这些数据的CSV文件。 我正在使用Vue,代码看起来像:
<button type="button" class="btn btn-info action_btn" v-on:click="downloadCSVData">
Download
</button>
如何编写downloadCSVData
函数?
我有一个名为csvdata
的字段,其中包含以下格式的数组:
[
[1,2,3],
[4,5,6],
[7,8,9]
]
我正在尝试下载这些数据的CSV文件。 我正在使用Vue,代码看起来像:
<button type="button" class="btn btn-info action_btn" v-on:click="downloadCSVData">
Download
</button>
如何编写downloadCSVData
函数?
假设csvdata
是您的Vue组件中可访问的数据属性,我认为您可以创建以下方法:
downloadCSVData() => {
let csv = 'Put,Column,Titles,Here\n';
this.csvdata.forEach((row) => {
csv += row.join(',');
csv += "\n";
});
const anchor = document.createElement('a');
anchor.href = 'data:text/csv;charset=utf-8,' + encodeURIComponent(csv);
anchor.target = '_blank';
anchor.download = 'nameYourFileHere.csv';
anchor.click();
}
function convertToCSV(objArray) {
const array = typeof objArray !== 'object' ? JSON.parse(objArray) : objArray;
let str = '';
for (let i = 0; i < array.length; i++) { // eslint-disable-line
let line = '';
for (const index in array[i]) { // eslint-disable-line
if (line !== '') line += ',';
line += array[i][index];
}
str += line + '\r\n'; // eslint-disable-line
}
return str;
}
function exportCSVFile(headers, items, fileTitle) {
if (headers) {
items.unshift(headers);
}
const jsonObject = JSON.stringify(items);
const csv = convertToCSV(jsonObject);
const exportedFilenmae = fileTitle + '.csv' || 'export.csv'; // eslint-disable-line
const blob = new Blob([csv], { type: 'text/csv;charset=utf-8;' });
if (navigator.msSaveBlob) { // IE 10+
navigator.msSaveBlob(blob, exportedFilenmae);
} else {
const link = document.createElement('a');
if (link.download !== undefined) {
const url = URL.createObjectURL(blob);
link.setAttribute('href', url);
link.setAttribute('download', exportedFilenmae);
link.style.visibility = 'hidden';
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
}
}
export default exportCSVFile;
function downloadCSVData () {
var array = [
[1,2,3],
[4,5,6],
[7,8,9]
];
var str = '';
for (var i = 0; i < array.length; i++) {
let line = '';
line = array[i].join(",");
str += line + '\r\n';
}
var blob = new Blob([str], { type: 'text/csv;charset=utf-8;' });
var link = document.createElement('a');
var url = URL.createObjectURL(blob);
link.setAttribute('href', url);
link.setAttribute('download', 'csvfilename.csv');
link.style.visibility = 'hidden';
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
let data = [[1,2,3], [4,5,6], [7,8,9]].join('\r\n').toString()
)let encoded_data = btoa(data)
)let iframe = document.createElement('iframe'); iframe.src = "data:application/octet-stream;base64," + encoded_data
document.body.appendChild(iframe)
。但是这种方法有一些缺点:
更好的方法是在服务器上创建临时文件并向用户提供该文件的链接。