已解決430363個問題，去搜搜看，總會有你想問的

Blob 在生成 csv 文件時跳過第一列

首頁猿問 Blob 在生成 csv...

Blob 在生成 csv 文件時跳過第一列

JavaScript

呼啦一陣風 2023-10-20 16:14:56

我正在嘗試使用 blob 類生成 CSV 文件。第一行工作正常，但其余行正在跳過第一列var ExcelIndex = ['"user_name","user_hash","authenticate_id","first_name","last_name","description","department","phone_home","phone_mobile","phone_work","phone_other","phone_fax","address_street","address_city","address_state","address_country","address_postalcode","Errors"'];var dataInSingleStringArray = new Array();dataInSingleStringArray.push(ExcelIndex[0], "\n");var ExcelInde = ['"user_name","user_hash","authenticate_id","first_name","last_name","description","department","phone_home","phone_mobile","phone_work","phone_other","phone_fax","address_street","address_city","address_state","address_country","address_postalcode","Errors"'];// var dataInSingleStringArray = new Array();dataInSingleStringArray.push(ExcelInde[0], "\n");window.URL = window.webkitURL || window.URL;var contentType = 'text/csv';var csvFile = new Blob([dataInSingleStringArray], {type: contentType});var a = document.createElement('a');a.setAttribute("style", "margin-left: 700px;font-size: 2em;")a.download = 'failed_data.csv';a.href = window.URL.createObjectURL(csvFile);a.textContent = 'Download File';document.getElementById('link').appendChild(a);<div id="link"></div>

查看完整描述

1 回答

呼喚遠方

TA貢獻1856條經驗獲得超11個贊

不要每次向數組添加數據時都添加“\n”，而是將數據添加到數組，然后用“\n”將其連接起來

var ExcelIndex = ['"user_name","user_hash","authenticate_id","first_name","last_name","description","department","phone_home","phone_mobile","phone_work","phone_other","phone_fax","address_street","address_city","address_state","address_country","address_postalcode","Errors"'];

var dataInSingleStringArray = new Array();

dataInSingleStringArray.push(ExcelIndex[0]);

var ExcelInde = ['"user_name","user_hash","authenticate_id","first_name","last_name","description","department","phone_home","phone_mobile","phone_work","phone_other","phone_fax","address_street","address_city","address_state","address_country","address_postalcode","Errors"'];

// var dataInSingleStringArray = new Array();

dataInSingleStringArray.push(ExcelInde[0]);

//console.log(dataInSingleStringArray);

//console.log(dataInSingleStringArray.join("\r\n"));

window.URL = window.webkitURL || window.URL;

var contentType = 'text/csv';

var csvFile = new Blob([dataInSingleStringArray.join("\n")], {type: contentType});

var a = document.createElement('a');

a.setAttribute("style", "margin-left: 700px;font-size: 2em;")

a.download = 'failed_data.csv';

a.href = window.URL.createObjectURL(csvFile);

a.textContent = 'Download File';

document.getElementById('link').appendChild(a);

反對回復 2023-10-20

1 回答
0 關注
113 瀏覽

關注

添加回答

舉報

0/150

提交

取消

亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

熱搜

最近搜索清空

Blob 在生成 csv 文件時跳過第一列

Blob 在生成 csv 文件時跳過第一列

1 回答

添加回答