JSON对象转换为csv格式在JavaScript [英] converting json object to csv format in javascript

问题描述

我想转换成设置为csv格式的JavaScript对象

I am trying to convert a javascript object set in to csv format

您可以得到的想法生根粉我的Javascript对象，如果你把它放在网上JSON解析器 http://json.parser.online。 FR /

You can get the idea abt my Javascript object, if you put it in online JSON parser http://json.parser.online.fr/

这是我怎么想WRK出来... BT它以失败告终.. http://jsfiddle.net/fHQzC/11 /

This is how I tried to wrk it out... bt it flopped.. http://jsfiddle.net/fHQzC/11/

我试图采取相应的价值术​​语和相应的称号，整个值必须在csv格式

I am trying to take the whole values corresponding to the value "term" and corresponding title in to csv format

有关预期的输出是像

Time,Dec 9, 2012 
News,Germany,election, Egypt,Revolution, Japan, Earthquake
Person,Obama, Beckham
Title,Pearce Snubs Beckham                                
Time,Dec 5, Birthday
Person, Lebron James
News,Italy,Euro 2012 Final

标题 - 热火的全国冠军

Title-Heats National Champions

和是否有可能下载Excel工作表的CSV文件中我发现堆栈一为新台币真正有用的...

and is it possible to download the csv file in excel sheet the one I found in stack was nt really useful...

推荐答案

您可以尝试为

$(document).ready(function () {

        // Create Object
        var items = [
              { name: "Item 1", color: "Green", size: "X-Large" },
              { name: "Item 2", color: "Green", size: "X-Large" },
              { name: "Item 3", color: "Green", size: "X-Large" }];

        // Convert Object to JSON
        var jsonObject = JSON.stringify(items);

        // Display JSON
        $('#json').text(jsonObject);

        // Convert JSON to CSV & Display CSV
        $('#csv').text(ConvertToCSV(jsonObject));
    });

和功能ConvertToCSV

and a function ConvertToCSV

// JSON to CSV Converter
        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 += ','

                    line += array[i][index];
                }

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

            return str;
        }

来源

这篇关于JSON对象转换为csv格式在JavaScript的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！