How to export JavaScript Json info to csv (on client side)?

Question

from array info to csv :

<script>

    function downloadCsv() {
        var data = arrCsvData;
        var csvContent = "data:text/csv;charset=utf-8,";
        data.forEach(function(infoArray, index) {

            dataString = infoArray.join(",");
            csvContent += index < data.length ? dataString + "
" : dataString;

        });

        var encodedUri = encodeURI(csvContent);
        var link = document.createElement("a");
        link.setAttribute("href", encodedUri);
        link.setAttribute("download", "my_data.csv");

        link.click();
    }

</script>

Similarly how can i export javascript json info to csv (on client side)??

Answer 1

Here is how we can download json array of array to cdv data format :

function downloadCsv() {
            var data = arrCsvData;
            var csvContent = "data:text/csv;charset=utf-8,";

                for (var key in data) {
                  if (data.hasOwnProperty(key)) {
                    data[key].unshift([key,""]);
                    for(var index=0;index<data[key].length;index++){
                        var elementArray = data[key][index];
                        data[key][index] = elementArray.join(",");
                    }
                    csvContent += data[key].join("
");
                  }
                  csvContent += "
";
                }
            var encodedUri = encodeURI(csvContent);
            var link = document.createElement("a");
            link.setAttribute("href", encodedUri);
            link.setAttribute("download", "graphData.csv");

            link.click();
        }

It worked for me :)