角JS JSON2CSV

Question

当我试图将ng表中的筛选数据下载到CSV时，我将将单行拆分为两行。

输出将类似于下面的

Row1包含三列

Item 1 | 12222-12228-14567-124568-18680-20940-18717-ABCDED-sdf_dsfsdf | X-Large

相反，我得到了

第1行

Item 1 | 12222-12228-14567-124568-18680-20940-18717-ABCDED-sdf_dsfsdf |

第二行

X-Large

这是我的密码

var data = [{ "name": "Item 1", "color": "12222-12228-14567-124568-18680-20940-18717-ABCDED-aSFDasdf_sdfsdf_dsfsdf", "size": "X-Large" },
     { "name": "Item 2", "color": "Green", "size": "X-Large" },
     { "name": "Item 3", "color": "Green", "size": "X-Large" }];

$scope.downloadData = function (data){
       var csv = $scope.JsonToCsv(data);         
}

$scope.JsonToCsv = function(objArray) {
var array = typeof objArray != 'object' ? JSON.parse(objArray) :objArray;
        var str = '';
        var line = '';
        var head = array[0];
        for (var index in array[0]) {
            var value = index + "";
            line += '"' + value.replace(/"/g, '""') + '",';
        }
        line = line.slice(0, -1);
        str += line + '\r\n';
        for (var i = 0; i < array.length; i++) {
            var line = '';
            for (var index in array[i]) {
                line += array[i][index] + ',';
            }
            line = line.slice(0, -1);
            str += line + '\r\n';
        }
        return str;
    }

有人能帮我找出我的代码出了什么问题吗？

Answer 1

我有一个工作代码为这个，我改变了根据您的需要。希望这也适用于你

            var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
            var str = '';
            var line = "";
            for (var index in array[0]) {
                line += index + ',';
            }
            line = line.slice(0, -1);
            str += line + '\r\n';
            for (var i = 0; i < array.length; i++) {
                var line = "";
                for (var index in array[i]) {
                    line += '"' + array[i][index] + '",';
                }
                line.slice(0, line.length - 1);
                str += line + '\r\n';
            }
            if (str == '') {
                alert("oops");
                return;
            }
            console.log(str);
            return str;

谢谢:)