以下是JSON数据:
"data": [
{
"character_id": "5785304882",
"id": 289222,
"login_status": {
"created": "2022-09-21T19:52:04.394",
"status": "Started Competition"
},
"name": "user_01",
"team": "DA ATRAX ESPORTS"
}
以下是JS代码:
gacworksheet.columns = [
{ header: "User Name", key: "name", width: 10 },
{ header: "Team Name", key: "team", width: 10 },
{ header: "Character ID", key: "character_id", width: 10 },
{ header: "Login Time", key: "loginTime", width: 10 },
{ header: "Login Status", key: "loginStatus", width: 10 },
];
var json = JSON.parse(result);
var userData = json['data'];
userData.forEach(user => {
for (var i = 0; i < userData.length; i++) {
var loginTime = userData[i].login_status.created;
var loginStatus = userData[i].login_status.status;
}
gacworksheet.addRow(user);
});
let gacdata = gacworksheet.getSheetValues();
gacMData = gacdata.map(function(r){
return [r[1],r[2],r[3],r[4],r[5]];
});
console.log(gacMData);
当I为console.log
时,数组中的数据为undefined
.如何将数组值设置为键?
Console.log(GacMData)的结果;
[
'User Name',
'Team Name',
'Character ID',
'Login Time',
'Login Status'
],
[ 'user_01', 'DA ATRAX ESPORTS', '5785304882', undefined, undefined ],
[ 'user_02', 'DA ATRAX ESPORTS', '5670142641', undefined, undefined ],