Automation Anywhere Excel Operations | Compare Excels and Update the Cells #32

[@RAHULKUMAR-rn4bt]

Oh! Wonderful. That's the video many people are looking for. Thanks QAL for such wonderful videos. It is really helpful😃. This is a kind of real time scenario based activity. Thanks a lot! Keep posting such real time based videos. Much appreciated!👏👏

[@qualityassurancelab7764]

Thank you so much, glad to know that you found it helpful

[@asadmahboob1123]

Nice video. It's an alternative to vlookup and countif in excel. We can use "increment" function to increase the counter value Also, instead of "Assign to number" we van use it in the variable like $RowNum.assign to number$ This will make the bot less complicated. Thank you QAL for the video, I keep on waiting for your notication:))👍👌

[@Cricketclashbox]

Could you provide those excel sheets in discription so we can practise

[@postman108]

I would like to get a tutorial video about read data from excel and update value of a node in xml if that node is found, else continue loop till all xml files updated in a folder using AA 2019

[@roshanjameer3610]

Hi , could you please help on below scenario We have excel data of column with Dates (Ranges from today to 50days) in that need to select dates from +5 days from today how can we do that ?. Ex:- if today is Monday need to select date from Saturday.

[@Artech.Ranjit]

I have my result as a numeric value, but using set cell command i have to put $numericVar.tostring$ and in excel file it shows as warning for each value. How to fix this any suggestion plz?

[@shrividhyavidhya1849]

Hi could you please suggest what to do in case of lakhs of records in my excel sheet. As it takes hours together when I tried

[@guthikondasatishreddy9409]

Where can I download these two files?

[@saicharanm6710]

Hi, your Explanation is incredible, would you please make a video on using Shared session variable

[@RUBALSNGL1]

In this case, if all three fields were matching, then the required cell value was updated. Suppose 2 out of 3 fields are matching and third field is blank in one of the datasets, and we want to set the required cell in this case. Then how to proceed.

[@escapeenrique]

Hi I am using AA2020 community edition and am not able to find NumberUtilities(Calculation) although increment and decrement are there, whats the alternative if i wish to do a complex calculation? Also we are using the iterator to iterate thru each row, infact we are reading data from each column by $[RecordVariable][Name/Index of Column]$, then do we have any alternative to use the same iterator to write/set value(instead of using a new variable to do the same)?

[@qualityassurancelab7764]

Hi, it looks strange that Calc action is not present, I'll look at the alternative and will get back to you. It is good to have different variables for read and write , if you are doing these actions together, to avoid the conflict.

[@escapeenrique]

@@qualityassurancelab7764 Thanks for your kind reply

[@mohamedtimor4114]

Hello thanks for the video I have an excel sheet that has 2 columns price and discount I want to count the new price after the discount and store it in a new column how can I do that, please

[@qualityassurancelab7764]

Please use NumberUtils -> Calc Action to calculate price after discount and write the value in excel

[@pandeyabha3913]

Hello

[@mrsjaya73]

Is there a way to do yh iui s using Uipath?

[@qualityassurancelab7764]

Yes, please checkout - kzbin.info/www/bejne/qoGwc3luocepbqc kzbin.info/www/bejne/jp60namwlq2af9k

[@Gossip666Girl]

Please create a video on task "Invoice Extraction" from RPA challenge.

[@keerthanarajagopal2872]

Hi mam, Thank you for this video. I’m having one doubt.Inorder to update we need to execute that program in each and every time or will it be automatically update?

[@tanveekate9874]

you are awesome !

[@chanducm608]

Please do more videos 🙏

[@akkararnandakesirinararwic9233]

Im also cant find the Calc Function also

[@qualityassurancelab7764]

I'll take a look, in the mean time, please use Increment action

[@RescueismyfavBreed]

@@qualityassurancelab7764 I used the increment function but I didn't get the output.

[@sudhanshuvats8293]

Hi, please share uipath video thanks

[@mohamedhosney7819]

please can you send me the Excel sheet?

[@satyamjaiswal6885]

thankyou miss

[@allenivenkatesh999]

We have one excel file in that we have open, closed and pending actions we need separate actions into 3 excels can you help on this?