Dears,
There is no value under the process below.
I used the message box to test the expression“Invoice.Sheet(“发票应收账款数据”).Cell(“AI”& CurrentIndex)”. It will show a value but not an address.
Is there a method to solve it?
Already which is there in your cell is the address …
Address is "AI" & currentindex
Or
Append .Address at the end and you would get the same value again
Invoice.Sheet(“发票应收账款数据”).Cell(“AI”& CurrentIndex).Address
Both would work
Cheers
Hi @jackie.yue ,
I believe the Expression used by you is the correct one. Could you let us know what is happening ? Are you not able to get the Output ? Is it getting an Error ?
Maybe also try the below :
Invoice.Sheet("发票应收账款数据").Cell("AI"&CurrentIndex.ToString)
Cannot get the output
In that field you should be provided only till cell…no .ToAddress…
You can add address if you want to find output which address you are using
May I know what you are trying to acheive
Cheers
Thanks Anil,
The purpose is to input the formula：“=ISNUMBER(MATCH(K2,‘E:\BaiduNetdiskWorkspace\Supporting\Invoice[Match list.xlsx]客商信息’!$A:$A,0))” into the excel.
I used the expression below
“=ISNUMBER(MATCH(K”&CurrentIndex.ToString &“,” & MatchList.Sheet(“客商信息”).Range(“A:A”).ToString & “,0)) "
to replace
“=ISNUMBER(MATCH(K”&CurrentIndex.ToString &”,‘E:\BaiduNetdiskWorkspace\Supporting\Invoice[Match list.xlsx]客商信息’!$A:$A,0))"
But the output is “=ISNUMBER(MATCH(K1,UiPath.Excel.RangeValue,0))”
WhWhich should be “=ISNUMBER(MATCH(K1,‘E:\BaiduNetdiskWorkspace\Supporting\Invoice[Match list.xlsx]客商信息’!$A:$A,0))”
Thanks Guys,
The problem has been solved by involveing the filepath。
1 Like