javascript - 使用 EmberJS 将 JSON 导出到 Excel

Question

我有一个由服务返回的 JSON 对象。我想通过单击按钮将其导出到 xls 或 excel 文件。

当我调用 get 服务时，服务器返回:

"objects": [
{
  "amount": 1000,
  "date": "2015-12-08",
  "description": "sdadas",
  "from_id": "Prateek",
  "id": 1,
  "to_id": "Prateek,Srabani,Jimmy"
},
{
  "amount": 132,
  "date": "2015-12-08",
  "description": "sdadas",
  "from_id": "Prateek",
  "id": 3,
  "to_id": "Jimmy"
},
{
  "amount": 3000,
  "date": "2015-12-08",
  "description": "asdsasa",
  "from_id": "Srabani",
  "id": 4,
  "to_id": "Prateek,Srabani,Jimmy"
},
{
  "amount": 2000,
  "date": "2015-12-08",
  "description": "asdsasa",
  "from_id": "Jimmy",
  "id": 5,
  "to_id": "Prateek,Srabani,Jimmy"
},
{
  "amount": 100,
  "date": "2015-12-08",
  "description": "adas",
  "from_id": "Srabani",
  "id": 6,
  "to_id": "Prateek"
}
]

除此之外，前端没有进行任何过滤。我必须将这个对象数组导出到 excel 中，键是列的标签，值是对应的行。

有人可以帮我处理 Handlebars 和 Controller 代码吗？

Answer 1

这是将 JSON 对象导出为 Excel 支持的格式的代码。效果很好。

$(document).ready(function(){
    $('button').click(function(){
        var data = $('#txt').val();
        if(data == '')
            return;

    JSONToCSVConvertor(data, "Vehicle Report", true);
});
});

function JSONToCSVConvertor(JSONData, ReportTitle, ShowLabel) {
//If JSONData is not an object then JSON.parse will parse the JSON string in an Object
    var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;

    var CSV = '';    
    //Set Report title in first row or line

    CSV += ReportTitle + '\r\n\n';

    //This condition will generate the Label/Header
    if (ShowLabel) {
        var row = "";

    //This loop will extract the label from 1st index of on array
    for (var index in arrData[0]) {

        //Now convert each value to string and comma-seprated
        row += index + ',';
    }

    row = row.slice(0, -1);

    //append Label row with line break
    CSV += row + '\r\n';
    }

    //1st loop is to extract each row
    for (var i = 0; i < arrData.length; i++) {
        var row = "";

    //2nd loop will extract each column and convert it in string comma-seprated
    for (var index in arrData[i]) {
        row += '"' + arrData[i][index] + '",';
    }

    row.slice(0, row.length - 1);

    //add a line break after each row
    CSV += row + '\r\n';
    }

    if (CSV == '') {        
        alert("Invalid data");
        return;
    }   

    //Generate a file name
    var fileName = "MyReport_";
    //this will remove the blank-spaces from the title and replace it with an underscore
    fileName += ReportTitle.replace(/ /g,"_");   

    //Initialize file format you want csv or xls
    var uri = 'data:text/csv;charset=utf-8,' + escape(CSV);

    // Now the little tricky part.
    // you can use either>> window.open(uri);
    // but this will not work in some browsers
    // or you will not get the correct file extension    

    //this trick will generate a temp <a /> tag
    var link = document.createElement("a");    
    link.href = uri;

    //set the visibility hidden so it will not effect on your web-layout
    link.style = "visibility:hidden";
    link.download = fileName + ".csv";

    //this part will append the anchor tag and remove it after automatic click
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
  }