interior.Color属性在32列以上无法正常获取 可以进行修改 但读不到
使用了两种方法进行定位 均无法操作成功 代码如下
const row = Application.ActiveSheet.Rows(2)
const col = row.Columns(33)
let interior = col.Interior
console.log(interior.Color)
let interior = Application.Range('AG2').Interior
console.log(interior.Color)
同样的写法可以成功获取到32列以内的color属性
const row = Application.ActiveSheet.Rows(2)
const col = row.Columns(32)
let interior = col.Interior
console.log(interior.Color)
let interior = Application.Range('AF2').Interior
console.log(interior.Color)