我一直在努力完成這項作業，但沒有任何成功。
這是要放置在沒有公式的地方的資料。所以，想法是合并這兩個陣列并立即放置。
array1 =
[
["item1","","","details1"],
["item2","","","details2"],
]
該陣列包含從將放置傳入資料的目標范圍抓取的公式，但由于需要公式，
array2 =
[
["","=iferror(VLOOKUP(A63,'Client List'!$A$1:$S,19,0),"")","=iferror(if(B63="Agency", 'Reference Info'!$C$7, VLOOKUP(A63,'Client List'!$A$1:$T,20,0)),"")",""],
["","=iferror(VLOOKUP(A64,'Client List'!$A$1:$S,19,0),"")","=iferror(if(B64="Agency", 'Reference Info'!$C$7, VLOOKUP(A64,'Client List'!$A$1:$T,20,0)),"")",""]
]
預期結果
array2 =
[
["item1","=iferror(VLOOKUP(A63,'Client List'!$A$1:$S,19,0),"")","=iferror(if(B63="Agency", 'Reference Info'!$C$7, VLOOKUP(A63,'Client List'!$A$1:$T,20,0)),"")","details1"],
["item2","=iferror(VLOOKUP(A64,'Client List'!$A$1:$S,19,0),"")","=iferror(if(B64="Agency", 'Reference Info'!$C$7, VLOOKUP(A64,'Client List'!$A$1:$T,20,0)),"")","details2"]
]
這是我的嘗試，但我似乎無法深究：
let finalRowValues = []
for (let a = 0; a < array2.length; a ) {
for (let n = 0; n < array1.length; n ) {
array2[a].forEach(function(value, j){
if(value == '' && array1[n][j] != ''){
finalRowValues.push(array1[n][j])
} else {
finalRowValues.push(value)
}
})
}
}
uj5u.com熱心網友回復：
如果不存在值，這是一種插入公式的簡單方法：
function myFunction() {
const formulas = [[]]
const values = [[]]
return values.map((row, rowIndex) => row.map((col, colIndex) => col || formulas[rowIndex][colIndex]))
}
uj5u.com熱心網友回復：
這是方法之一。
const array1 =
[
["item1","","","details1"],
["item2","","","details2"],
]
const array2 =
[
["",`=iferror(VLOOKUP(A63,'Client List'!$A$1:$S,19,0),"")`,`=iferror(if(B63="Agency", 'Reference Info'!$C$7, VLOOKUP(A63,'Client List'!$A$1:$T,20,0)),"")`,""],
["",`=iferror(VLOOKUP(A64,'Client List'!$A$1:$S,19,0),"")`,`=iferror(if(B64="Agency", 'Reference Info'!$C$7, VLOOKUP(A64,'Client List'!$A$1:$T,20,0)),"")`,""]
]
const result = array1.map((arr, i) => {
const [place1, place2, place3, place4] = arr
if(place2 == ""){
return [place1, array2[i][1], array2[i][2],place4]
} else {
return arr
}
})
console.log(result)
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/492071.html
上一篇：我如何從下拉串列中獲取值字串