在javascript中将json对象转换为csv格式 [英] converting json object to csv format in javascript
问题描述
我试图将一个javascript对象设置为csv格式
你可以得到想法abt我的Javascript对象,如果你把它放在在线JSON解析器< a href =http://json.parser.online.fr/ =noreferrer> http://json.parser.online.fr/
这是我试图wrk它... bt它翻牌.. http:// jsfiddle .net / fHQzC / 11 /
我试图取对应于值term和相应标题的整个值到csv格式
预期输出为
时间,2012年12月9日
新闻,德国,选举,埃及,革命,日本,地震
人,奥巴马,贝克汉姆
标题,Pearce Snubs Beckham
时间,12月5日,生日
人, Lebron James
新闻,意大利,欧洲2012决赛
职业冠军全国冠军
可以下载csv文件在excel表中我发现在堆栈是nt真的有用...
您可以尝试
{
// 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 }];
//将对象转换为JSON
var jsonObject = JSON.stringify(items);
//显示JSON
$('#json')。text(jsonObject);
//将JSON转换为CSV&显示CSV
$('#csv')。text(ConvertToCSV(jsonObject));
});
和函数ConvertToCSV
// JSON to CSV Converter
function ConvertToCSV(objArray){
var array = typeof objArray!='object'? JSON.parse(objArray):objArray;
var str ='';
for(var i = 0; i var line ='';
for(array [i]中的var index){
if(line!='')line + =','
line + = array [i] [index ];
}
str + = line +'\r\\\
';
}
return str;
}
I am trying to convert a javascript object set in to csv format
You can get the idea abt my Javascript object, if you put it in online JSON parser http://json.parser.online.fr/
This is how I tried to wrk it out... bt it flopped.. http://jsfiddle.net/fHQzC/11/
I am trying to take the whole values corresponding to the value "term" and corresponding title in to csv format
The expected output for is like
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
and is it possible to download the csv file in excel sheet the one I found in stack was nt really useful...
you can try as
$(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));
});
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;
}
这篇关于在javascript中将json对象转换为csv格式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!