javascript array to csv string
var colors = ["red", "blue", "green"]; var colorsString = colors.join(","); //"red,blue,green"
js array to csv
const arrayToCSV = (arr, delimiter = ',') => arr.map(v => v.map(x => `"${x}"`).join(delimiter)).join('\n');
js array to csv download
function exportToCsv(filename, rows) { var processRow = function (row) { var finalVal = ''; for (var j = 0; j < row.length; j++) { var innerValue = row[j] === null ? '' : row[j].toString(); if (row[j] instanceof Date) { innerValue = row[j].toLocaleString(); }; var result = innerValue.replace(/"/g, '""'); if (result.search(/("|,|\n)/g) >= 0) result = '"' + result + '"'; if (j > 0) finalVal += ','; finalVal += result; } return finalVal + '\n'; }; var csvFile = ''; for (var i = 0; i < rows.length; i++) { csvFile += processRow(rows[i]); } var blob = new Blob([csvFile], { type: 'text/csv;charset=utf-8;' }); if (navigator.msSaveBlob) { // IE 10+ navigator.msSaveBlob(blob, filename); } else { var link = document.createElement("a"); if (link.download !== undefined) { // feature detection // Browsers that support HTML5 download attribute var url = URL.createObjectURL(blob); link.setAttribute("href", url); link.setAttribute("download", filename); link.style.visibility = 'hidden'; document.body.appendChild(link); link.click(); document.body.removeChild(link); } } }
Source: stackoverflow.com
js array to csv download
const rows = [ ["name1", "city1", "some other info"], ["name2", "city2", "more info"] ]; let csvContent = "data:text/csv;charset=utf-8," + rows.map(e => e.join(",")).join("\n");
Source: stackoverflow.com
convert array to csv javascript
var objectToCSVRow = function(dataObject) { var dataArray = new Array; for (var o in dataObject) { var innerValue = dataObject[o]===null?'':dataObject[o].toString(); var result = innerValue.replace(/"/g, '""'); result = '"' + result + '"'; dataArray.push(result); } return dataArray.join(' ') + '\r\n'; } var exportToCSV = function(arrayOfObjects) { if (!arrayOfObjects.length) { return; } var csvContent = "data:text/csv;charset=utf-8,"; // headers csvContent += objectToCSVRow(Object.keys(arrayOfObjects[0])); arrayOfObjects.forEach(function(item){ csvContent += objectToCSVRow(item); }); var encodedUri = encodeURI(csvContent); var link = document.createElement("a"); link.setAttribute("href", encodedUri); link.setAttribute("download", "customers.csv"); document.body.appendChild(link); // Required for FF link.click(); document.body.removeChild(link); }
Source: stackoverflow.com