Match and Paste Data Across Sheets | Loop Datatables | UiPath | (Excel Automation UiPath) | RPA

[@AnilKumar-mo3pr]

Thanks. it was helpful to learn.

[@MukeshKala]

Thank you 😊

[@shrutikadongre1046]

Thanks for this video!

[@MukeshKala]

Glad it helped 🤩

[@NikoleXu]

Hi I am very new to using UI path and would like to ask how do you get the options to change the type at around 8:22 to 8:26 in the video? Thanks!

[@MukeshKala]

So , we just type dot ( .) and editor would show all options , you can also press (Alt _ SPACE) to get the options

[@SaritaShukla-eb5ih]

Can we use this logic for pasting data from excel file to word file template?

[@MukeshKala]

This can help in matching data , For Pasting Data in word - refer the below video kzbin.info/www/bejne/b6qmZ3qPmcyMetU

[@parvathyks320]

For each row, can you please name the activity you used here?

[@MukeshKala]

Search for each in activities

[@parvathyks320]

@@MukeshKala I did that, I think there is a difference in the version, maybe, for me there is an option called item also, hope it is for the row

[@gattuakhil2319]

superb bro

[@MukeshKala]

Thank you 😊

[@shrishakthikumaresan3940]

Hi sir can you give a video link which is related to opportunity count in uipath..

[@MukeshKala]

Which opportunity count , can you elaborate?

[@nehapatel8696]

Actually wanted to ask that if I have huge amount of data and need to compare sheets and update on another sheet, if the value didn't match because of spelling mistake or extra wording, so how can we do that and we can't correct it manually because its a huge data, so can you please explain how can I do that ?

[@MukeshKala]

The approach we are using here is one by one comparison - so if the data is Huge - it would take more time ... The Other approach is to use LINQ which could do this task in much faster way

[@andyyeo5757]

Excellent instructional video, Mukesh. May I know where I can get the Excel data files you used in this instructional video? Thanks a million

[@MukeshKala]

Sent Mail

[@kumarjp1416]

Hi Mukesh.. Thanks for the knowledge 1) Instead of counter can we make use of the Index Property in For Each row? 2) you have used 2 for each reach. if the data is huge it'll take time to execute so, is there any other way we can achieve the same using LINQ queries so that code complexity also reduces

[@MukeshKala]

1. Yes we can - kzbin.info/www/bejne/iXa1fp57qLyFgsU - Please refer this video on using Index 2. Absolutely LINQ would always be a preference.

[@sangitaandhale1673]

Hi Mukesh, Thank you for your video i have the same requirement only the case is i have the excel row more than 1Lakh and need to compare the excel row with new excel file having the same no or less no of rows. To increase the speed of the bot could you please help me. As to processing 1lac rows bot took 2hrs? I need to reduce the time of performance. Your response is very valuable for me

[@MukeshKala]

2 Ways we can Do It : 1. Use Excel as a Database 2. Apply LINQ Queries and save time for Looping the Data

[@sangitaandhale1673]

@@MukeshKala please provide me linq expression for same..i am stuck

[@MukeshKala]

for comparing and writing data first take for each loop and iterate Source datatable after that in body use LINQ query in if condition "(From NewDt in MasterDT where main(1) .ToString.Trim.Equals (NewDt(0).toString.trim) Select NewDt) ToArray count>O" after that store this value in one data table resultdt = (From NewDt in MasterDT where main (1).ToString.Trim.Equals (NewDt(0).toString.trim) Select NewDt).Copytodatatable after that take assign activity and assign the value in source data table by writing source (9)=result (0) (3) tostring.

[@rash9892]

Hey Mukesh,

[@MukeshKala]

Hello

[@rash9892]

@@MukeshKala actually, this is about a query

[@rash9892]

R u conducting any live classes for uipath? Or at the least possibility, do you provide any recorded sessions?

[@MukeshKala]

Yes I do take live sessions we are doing in Hindi language now … all previous one are available here kzbin.info/aero/PLEYSwx3duQ2AZKIUewc2phz6sjzOv42q3

[@rash9892]

@@MukeshKala if you could reply this, that'd be much helpful.