1月26日之后就开始报错,之前运行很好(Airscript1.0)
WOApiError:CoreExecError: E_ET_COMPILE_GENERAL_ERROR报这个错
activesheet.Range("AK" + matchrow).Formula = `=IFERROR(XLOOKUP("*"&IF(ISNUMBER(SEARCH("一二",$F${matchrow},1)),LEFT($F${matchrow},LEN($F${matchrow})-SEARCH("一二",$F${matchrow},1)-1),LEFT($F${matchrow},LEN($F${matchrow})-1))&"*"&IF(LEFT($H${matchrow},1)="0",IF(LEFT($H${matchrow},2)="00",MID($H${matchrow},3,LEN($H${matchrow})-3),MID($H${matchrow},2,LEN($H${matchrow})-2)),LEFT($H${matchrow},LEN($H${matchrow})-1)),[110kV及以上属地台账.ksheet]线路台账!$E:$E&[110kV及以上属地台账.ksheet]线路台账!$G:$G,[110kV及以上属地台账.ksheet]线路台账!$H:$H,"XXX",2,1),"")`
fillrange = activesheet.Range(`AK${matchrow}: AK${rowend}`)
activesheet.Range("AK" + matchrow).AutoFill(fillrange, xlFillDefault)
console.log(`AK列公式写入成功!`)
@金山办公
创作者俱乐部成员