UiPath Tutorial | Uipath Lookup Range Practice

[@jagirapuvishwateja6258]

great example and great explanation .thank you.

[@sprittube7237]

We watch all your videos...

[@online-academy2579]

hi rakesh by using remove we can remove the letter B from Cell name. Outpur.Remove(0,1). Outpur is my variable name.

[@user-qf3kj7mh5m]

Yes i did the same and incremented it by +1 . worked flawlessly With simple steps.

[@ravuri999]

Thank you so much , The example was so tricky

[@alfredpereira9152]

You've got brains bro

[@rpalearner9818]

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...

[@balanirmalbala4446]

Nice work bro

[@shubhamjaiswal3624]

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

[@ajay397]

Flawless rakesh..worth watching every second.

[@AutomatewithRakesh]

Thank you Ajay👍

[@rohitagarwal2601]

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 *

[@tejaswinerella5223]

@rohit I'm also facing the same issue Have you resolve this issue? Can you please help me

[@jayaseelans370]

Great work. Really appreciated.

[@manjiri3539]

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.

[@pavanvallu9209]

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

[@vijaydasari-x4p]

Consider in B19 we have only "Clock" keyword and we need get that range. How do we get it.

[@nitaprasad3855]

very nicely explained........quite tricky one ........

[@AutomatewithRakesh]

Thanks Nita

[@suryakiranaluru6212]

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.

[@silpabandi-uq7jh]

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

[@irfanaanjum3243]

i got confused help me to understand after 19 minutes of video @Rakesh will you give me the online classes

[@vishnuprasad9619]

Super

[@waldemarzielinski6958]

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

[@tejaswinerella5223]

@Waldemar I'm also facing the same issue Have you resolve this issue? Can you please help me...

[@rohitagarwal2601]

Rakesh, I am unable to implement sort table Excel activity. Everytime, throwing some exception. Can you help ?

[@AutomatewithRakesh]

Which version of excel are you using?

[@rohitagarwal2601]

@@AutomatewithRakesh that's the catch. Don't have office and am using wps 😔

[@SyedAli-iq4ku]

I did as you did Rakesh

[@prashantrai5911]

Sir this can we get without using substring method.i done it and I find the cell value without writings substring method

[@ravuri999]

Can you please tell me that

[@lugkenish93]

Hi, I unable to get "CellIndexValue" dropdown, why? I'm using Uipath version 2019.10.4

[@lugkenish93]

i gt it, its lookup range value.

[@vignaharikarthikv11]

Nice Work. It will be good if you upload the sample excel sheets

[@AutomatewithRakesh]

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!

[@AutomatewithRakesh]

As always do not forget to hit on the LIKE button for the videos you are watching! Pls support and motivate us!

[@jojiparayidathilcherian9792]

You should have used Regex instead of sub string to get digit only.

[@AutomatewithRakesh]

Thanks for posting Joji, yes your opinion is valid we can use that, Regex is another way and should be learnt!

[@kondalaniranjanreddy7348]

Why not for each

[@AutomatewithRakesh]

Yes, we can built various logics to do the same thing, however Look UP Range serves the purpose