我從行和列中獲取范圍，并將它們組合成一個表格資料集，其中列中的日期被帶入行中，并且對資料的報告變得更加容易。
Tanaike 好心地提供了一個解決方案，但是當我對其進行調整并將其應用于不同的情況時，它沒有將第一個和最后一個元素放入結果陣列中，我不知道為什么 - 顯然，因為我仍然沒有不知道map()，flatMap()等等……
這些是資料集：
const dates = ["01/31/2021","02/28/2021","03/31/2021","04/30/2021","05/31/2021","06/30/2021","07/31/2021","08/31/2021","09/30/2021","10/31/2021","11/30/2021","12/31/2021","01/31/2022","02/28/2022","03/31/2022","04/30/2022","05/31/2022","06/30/2022","07/31/2022","08/31/2022","09/30/2022","10/31/2022","11/30/2022","12/31/2022","01/31/2023","02/28/2023","03/31/2023","04/30/2023","05/31/2023","06/30/2023","07/31/2023","08/31/2023","09/30/2023","10/31/2023","11/30/2023","12/31/2023","01/31/2024","02/29/2024","03/31/2024","04/30/2024","05/31/2024","06/30/2024","07/31/2024","08/31/2024","09/30/2024","10/31/2024","11/30/2024","12/31/2024","01/31/2025","02/28/2025","03/31/2025","04/30/2025","05/31/2025","06/30/2025","07/31/2025","08/31/2025","09/30/2025","10/31/2025","11/30/2025","12/31/2025"]
const data = [[1,"Owner Test","CEO","Salary",283000,"","2021-01-31T08:00:00.000Z","2021-02-28T08:00:00.000Z",23583.333333333332,23583.333333333332,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],[2,"Employee Test","Content Creator","Salary",37000,40,"2021-01-31T08:00:00.000Z","2021-10-31T07:00:00.000Z",3083.3333333333335,3083.3333333333335,3083.3333333333335,3083.3333333333335,3083.3333333333335,3083.3333333333335,3083.3333333333335,3083.3333333333335,3083.3333333333335,3083.3333333333335,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]]
代碼片段
const [, ...d] = dates;
const [id, name, position, workType, rate, hourWeek, dateHired, terminationDate, ...values] = data[0].map((_, c) => data.map(r => r[c]));
let res = d.flatMap((e, i) => id.map((f, j) => [e, f, name[j], position[j], workType[j], rate[j], hourWeek[j], dateHired[j], terminationDate[j], values[i][j]]));
結果陣列不包括第一個日期和最后一個日期......
感謝任何方向/幫助！
uj5u.com熱心網友回復：
在您的腳本中，如何進行以下修改？
從：
const [, ...d] = dates;
至：
const d = dates;
- 當我看到您的示例值時
dates，第一個元素不為空。因此，在這種情況下，我認為您可以使用dates.
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/493349.html
下一篇：洗掉最后一個元素的邊框底部