如何将 json 字符串转换为 google.visualization.DataTable？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/16896219/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-03 19:49:39 来源:igfitidea点击:
How can I convert json string to google.visualization.DataTable?
提问by Njax3SmmM2x2a0Zf7Hpd
I am getting a json string from the response. How can I create a data table from that?
我从响应中得到一个 json 字符串。如何从中创建数据表？
e.g.
例如
var jasonString = "..........";
var data = new google.visualization.DataTable(jasonString);
回答by Diode
You can use the function arrayToDataTable
您可以使用函数arrayToDataTable
var jsonString = ".........."; // json string of array
var array = JSON.parse(jsonString);
var dataTableData = google.visualization.arrayToDataTable(array);
// use dataTableData to build dataTable
回答by Jeff Baldwin
回答by Fábio Rodrigues Fonseca
You can do:
你可以做：
google.charts.load('current', { 'packages': ['line'] });
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var json = $.ajax({
url: "GetFaturamentoMes",
dataType: "json",
success: function (jsonData) {
var data = new google.visualization.DataTable();
data.addColumn('number', 'Mês');
data.addColumn('number', 'Faturamento Por Mês');
for (var i = 0; i < jsonData.length; i++) {
mes = jsonData[i].Mes;
total = jsonData[i].Total;
data.addRow([mes, total]);
}
var options = {
chart: {
title: 'Gráfico de Faturamento Mensal',
subtitle: 'Moeda (R$)'
},
width: 600,
height: 300,
axes: {
x: {
10: { side: 'top' }
}
}
};
var chart = new google.charts.Line(document.getElementById('line_top_x'));
chart.draw(data, google.charts.Line.convertOptions(options));
}
});
}
