JS宏使用fast-diff库标记单元格的不同之处

function tt()

{

const a = Range('A1:C10').Value2

const b = Range('E1:G10').Value2

for (let i = 0; i < a.length; i++) {

for (let j = 0; j < a[0].length; j++) {

if (typeof a[i][j] !== 'string') continue

const t = fd(a[i][j], b[i][j])

Cells(i + 1, j + 9).Value2 = t.map(x=>x[1]).join('')

let x = 1

for (const k of t) {

if (k[0] < 0) {

Cells(i + 1, j + 9).Characters(x, k[1].length).Font.Color = 0xff

Cells(i + 1, j + 9).Characters(x, k[1].length).Font.Strikethrough = true

}

if (k[0] > 0) {

Cells(i + 1, j + 9).Characters(x, k[1].length).Font.Color = 0xff

}

x += k[1].length

}

}

}

}