I have the following array (transposed) given:
[
[ 'Holiday', 'Date', 'Typ' ],
[ 'Neujahr', 44197, 'FIXED' ],
[ 'Heilige Drei Könige', 44202, 'REOCCURING' ],
[ '…', '…', '…' ]
]
What I need:
{
"holidays": [
{
"name": "Neujahr",
"date": "01.01.2021",
"type": "RECURRING"
},
...
]
}
What I tried to use is this switch case:
const output: any = index.reduce((acc: any, curr: number, idx: number) => {
switch (curr) {
case 0:
acc.name = transposed[1][0];
break;
case 1:
acc.date = DateTimeUtil.xlDateConvert(transposed[idx][1]);
break;
case 2:
acc.type = transposed[idx][2];
break;
default:
break;
}
return acc;
}, {});
But this does not work as I get this as a result:
{
name: 'Neujahr',
date: '2021-01-01T00:00:00.000Z',
type: 'REOCCURING',
}