本文介绍了如何将JavaScript Json信息导出到csv(在客户端)?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
从数组信息到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:
这篇关于如何将JavaScript Json信息导出到csv(在客户端)?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!