如何将JavaScript Json信息导出到csv(在客户端)? [英] How to export JavaScript Json info to csv (on client side)?

问题描述

从数组信息到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 + "\n" : dataString;

        });

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

        link.click();
    }

</script>

类似地，我如何将javascript json信息导出到csv(在客户端)?

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

推荐答案

我对这个确切的问题进行了自己的实现.

I made my own implementation of this exact problem.

它将JSON对象的JSON数组转换为Office 365 Excel中可读的CSV文件.

It translates a JSON array of JSON objects to a CSV file readable in Office 365 Excel.

我用它将工作表转换为Excel工作表.

I use it to convert a table for work into a excel sheet.

    var jsonData = [
        {
            "Object": "Object",
            "AnotherObject": "AnotherValue"
        },
        {
            "Object": "SecondObject",
            "AnotherObject": "SecondValue"
        }
    ];
    WriteCSV(jsonData);

将在Excel中给出此信息

Would give this in Excel:

截屏Excel

Github页面

这篇关于如何将JavaScript Json信息导出到csv(在客户端)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！