官方文档有个Find的例子，大概能用
function test() {
let ret = []
let add = ActiveSheet.UsedRange
let c = add.Find('8', undefined, xlValues)
if (c != null) {
let firstAddress = c.Address()
ret.push(firstAddress)
do {
c = add.FindNext(c)
ret.push(c.Address())
}while (c != null && c.Address() != firstAddress)
}
console.log(JSON.stringify(ret))
}
创作者俱乐部成员