arrays - 将 JSON 数组输出打印到 Google Sheet

Question

我正在尝试解析 Google 脚本中 JSON 数组的输出并将其打印到工作表中。工作表中的预期输出:

• 第 1 行:澳元 |新年 |英镑|港元
• 第 2 行:0.98 | 5.01 | 5.01 0.56 | 0.56 5.60
• 第 3 行:0.91 | 8.01 | 0.93 | 0.93 2.61

我目前正在使用下面的脚本，它的输出为

• 第 1 行:{澳元=0.98、港元=5.01、英镑=0.56、人民币=5.60}
• 第 2 行:{澳元=0.91、港元=8.01、英镑=0.93、人民币=2.61}

任何人都可以帮助我解决这里缺少的问题吗？

    function addObject(){
     var obj = {
        "base": "CAD",
        "date": "2017-05-05",
        "rates": [{
            "AUD": "0.98",
            "CNY": "5.01",
            "GBP": "0.56",
            "HKD": "5.60"
        },
                 {
            "AUD": "0.91",
            "CNY": "8.01",
            "GBP": "0.93",
            "HKD": "2.61"
        }]
    }
    var inputArray = []
    var rates = obj.rates
    for (var j in rates){
      inputArray.push([rates[j]])
    }
    Logger.log(inputArray)
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getSheetByName('Sheet1');
    sheet.getRange(sheet.getLastRow()+1, 1,inputArray.length,inputArray[0].length).setValues(inputArray)

    }

Answer 1

您需要将数组转换为二维数组:

let obj = {
    "base": "CAD",
    "date": "2017-05-05",
    "rates": [{
        "AUD": "0.98",
        "CNY": "5.01",
        "GBP": "0.56",
        "HKD": "5.60"
    },
             {
        "AUD": "0.91",
        "CNY": "8.01",
        "GBP": "0.93",
        "HKD": "2.61"
    }]
}

let headers = Object.keys(obj.rates[0]);
let out = obj.rates.map(({AUD,CNY,GBP,HKD})=> [AUD,CNY,GBP,HKD]);
out.unshift(headers);
console.log(out);//setvalues this array: out