Good Work ji.. Carry on.. No one have done this video as like yours... Hoping lot more.. Also possible do simple SQL database based project in REFRAME Work.. Thanks for the Video...
Hello sir your videos are very knowledgeable. In this example we can loop it till lookup return empty string. and replace look up output value with the range in lookup activity
I chose the condition as svalue < = 18 with last cell having the search value and it provided the result. However, when not entering the search value in last cell, it is throwing error " object reference not set to an instance of the object *
Hi... Your videos are really helpful. Thanks a lot. I would like to participate in your 5 hour weekend session of orchestrator. Regarding above assignment, Are we able to do using For Each Loop And DataTable? I am stuck at how to iterate or manage to get value at row level.
Hi Sir, in your example, you have given the range like B2:B18. you know the range thats why you can able to give, if i am working in real time example with different excels with diff ranges, in that case how can i mention the range. could you please let me know.
thanks for the video rakesh , very clear like always I have the same issue with rohit , all the index are found in the first loop but when its start the second it is throwing error " object reference not set to an instance of the object * on Clenght I tried to put a defaut value 0 or 1 but nothing
good example but when i am doing this i am get an error like this Assign: Object reference not set to an instance of an object. please help me to reslove
Thank you for the suggestion, Yes, that excel file I had created manually long back, I hardly could find that file now. Going forward you will try to upload the file for practice purpose!
great example and great explanation .thank you.
We watch all your videos...
Thank you so much , The example was so tricky
You've got brains bro
Good Work ji.. Carry on.. No one have done this video as like yours... Hoping lot more.. Also possible do simple SQL database based project in REFRAME Work.. Thanks for the Video...
Flawless rakesh..worth watching every second.
Thank you Ajay👍
Hello sir your videos are very knowledgeable.
In this example we can loop it till lookup return empty string.
and replace look up output value with the range in lookup activity
hi rakesh by using remove we can remove the letter B from Cell name.
Outpur.Remove(0,1).
Outpur is my variable name.
Yes i did the same and incremented it by +1 . worked flawlessly With simple steps.
Great work. Really appreciated.
very nicely explained........quite tricky one ........
Thanks Nita
I chose the condition as svalue < = 18 with last cell having the search value and it provided the result. However, when not entering the search value in last cell, it is throwing error " object reference not set to an instance of the object *
@rohit I'm also facing the same issue
Have you resolve this issue?
Can you please help me
Nice work bro
Hi... Your videos are really helpful. Thanks a lot. I would like to participate in your 5 hour weekend session of orchestrator.
Regarding above assignment, Are we able to do using For Each Loop And DataTable? I am stuck at how to iterate or manage to get value at row level.
Super
hello sir can you explain any chances to pick a random name fom a excel sheet . Like names or numbers should be pick randomly in that row
I did as you did Rakesh
Hi Sir, in your example, you have given the range like B2:B18. you know the range thats why you can able to give, if i am working in real time example with different excels with diff ranges, in that case how can i mention the range. could you please let me know.
Consider in B19 we have only "Clock" keyword and we need get that range. How do we get it.
thanks for the video rakesh , very clear like always
I have the same issue with rohit , all the index are found in the first loop but when its start the second it is throwing error " object reference not set to an instance of the object * on Clenght
I tried to put a defaut value 0 or 1 but nothing
@Waldemar I'm also facing the same issue
Have you resolve this issue?
Can you please help me...
good example but when i am doing this i am get an error like this
Assign: Object reference not set to an instance of an object.
please help me to reslove
i got confused help me to understand after 19 minutes of video @Rakesh will you give me the online classes
Nice Work. It will be good if you upload the sample
excel sheets
Thank you for the suggestion, Yes, that excel file I had created manually long back, I hardly could find that file now. Going forward you will try to upload the file for practice purpose!
As always do not forget to hit on the LIKE button for the videos you are watching! Pls support and motivate us!
Sir this can we get without using substring method.i done it and I find the cell value without writings substring method
Can you please tell me that
Hi,
I unable to get "CellIndexValue" dropdown, why?
I'm using Uipath version 2019.10.4
i gt it, its lookup range value.
Rakesh, I am unable to implement sort table Excel activity. Everytime, throwing some exception. Can you help ?
Which version of excel are you using?
@@AutomatewithRakesh that's the catch. Don't have office and am using wps 😔
You should have used Regex instead of sub string to get digit only.
Thanks for posting Joji, yes your opinion is valid we can use that, Regex is another way and should be learnt!
Why not for each
Yes, we can built various logics to do the same thing, however Look UP Range serves the purpose