Breaking News: Grepper is joining You.com. Read the official announcement!

array to excel javascript

D3signa answered on March 19, 2022 Popularity 9/10 Helpfulness 4/10

answer array to excel javascript

array to excel javascript

Comment

//my solution was export as csv and opn file directly in excel
//here is how i didit its in spanish sorry nut you can always google translate

https://asfo.medium.com/exportando-un-json-a-csv-con-javascript-410aee9381d8


function convertToCSV(objArray) {
    var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
    var str = '';

    for (var i = 0; i < array.length; i++) {
        var line = '';
        for (var index in array[i]) {
            if (line != '') line += ','

			if (array[i][index] != null){
				line += array[i][index];
			} else {
				line += ''
			}
        }

        str += line + '\r\n';
    }

    return str;
}

function exportCSVFile(headers, items, fileName) {
 if (headers) {
  items.unshift(headers);
 }

const jsonObject = JSON.stringify(items);

const csv = convertToCSV(jsonObject);

const exportName = fileName + ".csv" || "export.csv";

const blob = new Blob([csv], { type: "text/csv;charset=utf-8;" });
 if (navigator.msSaveBlob) {
  navigator.msSaveBlob(blob, exportName);
 } else {
  const link = document.createElement("a");
  if (link.download !== undefined) {
   const url = URL.createObjectURL(blob);
   link.setAttribute("href", url);
   link.setAttribute("download", exportName);
   link.style.visibility = "hidden";
   document.body.appendChild(link);
   link.click();
   document.body.removeChild(link);
  }
 }
}


const headers = {
 id: 'Identificador',
 nombre: 'Nombre'
};

const data = [
 { id: 1, nombre: 'John Doe' },
 { id: 2, nombre: 'Juan' },
 { id: 3, nombre: 'Samanta' }
];

exportCSVFile(headers, data, 'nombres');

Popularity 9/10 Helpfulness 4/10 Language javascript

Source: Grepper

Tags: excel javascript

Link to this answer
Share Copy Link

Contributed on Mar 19 2022

D3signa

0 Answers Avg Quality 2/10

array to excel javascript

Contents

More Related Answers

array to excel javascript

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.