Executing Excel Formula using datatable

Help Studio
, ,
21

Please make sure that you are using correct quotes in the formula:

Sometimes when copying formulas from UiPath forum they need manual updating inside UiPath Studio.

This is how it looks like for me when I download you .xaml file:

image
image1653×50 15.3 KB

and this is how it should look like:

image
image1627×46 7.89 KB

Please check all of the quotes if they are correct.

22

i just downloaded your code and run it with the formula:

(“=IF(AND(J”+Counter.ToString+“=”+Chr(34) +“non”+Chr(34) +“;OR(D”+Counter.ToString+“=”+Chr(34) +“TVX”+Chr(34) +“;D”+Counter.ToString+“=”+Chr(34)+“PDD”+Chr(34)+“;D”+Counter.ToString+“=”+Chr(34) +“CICM”+“=”+Chr(34) +“;D”+Counter.ToString+“=”+Chr(34)+“EF”+Chr(34)+“));”+Chr(34)+“654200”+Chr(34)+“;”+Chr(34)+“654100”+Chr(34)+“)”).Replace(“;”,“,”)

but it did always give :

image
image1920×1080 278 KB

23

Did you try deleting .Replace(“;”,“,”) ? I added this since I use , as a separator in Excel, not ;

24

always the same thing, now i’m getting “Read range errorI dentifier expected”

25

any help :slight_smile: ?
sample.xlsx (15.9 KB)
test (1) (1).xaml (41.8 KB)