如何根据数据源和表头数据计算单元格位置？

Question

// 
let thisDataSource = [
    {
        "YYRZJHM": "吃这些1",
        "YYRZJLX": "asd1",
        "NAME": "冲冲冲1",
        "OTHER_FIELD": "其他值1"
    },
    {
        "YYRZJHM": "吃这些2",
        "YYRZJLX": "asd2",
        "NAME": "冲冲冲2",
        "OTHER_FIELD": "其他值2"
    },
    {
        "YYRZJHM": "吃这些3",
        "YYRZJLX": "asd3",
        "NAME": "冲冲冲3",
        "OTHER_FIELD": "其他值3"
    }
];

// 假设这是你的arr数组，示例数据结构，实际情况根据你的需求而定
let arr = [
    {
        "m": "认证号码类型",
        "ct": {
            "fa": "General",
            "t": "g"
        },
        "v": "认证号码类型",
        "row": 1,
        "column": 0,
        "FIELD": "YYRZJLX"
    },
    {
        "m": "认证号码",
        "ct": {
            "fa": "General",
            "t": "g"
        },
        "v": "认证号码",
        "row": 1,
        "column": 1,
        "FIELD": "YYRZJHM"
    },
    {
        "m": "姓名",
        "ct": {
            "fa": "General",
            "t": "g"
        },
        "v": "姓名",
        "row": 1,
        "column": 2,
        "FIELD": "NAME"
    }
];

arr数组是表头数据，arr里面的row和column是单元格位置，arr的FIELD的值对应数据源的键

Answer 1

let result = [];

thisDataSource.forEach((data, dataIndex) => {
    arr.forEach(header => {
        if (data.hasOwnProperty(header.FIELD)) {
            result.push({
                value: data[header.FIELD],
                row: header.row + dataIndex, // 根据数据源的索引调整行号
                column: header.column
            });
        }
    });
});

console.log(result);