UiPath | How to Merge multiple Excel sheets and write to a new sheet or Excel | What and How Series

[@csat2710]

Thank you sir now i got enough knowledge to read, write, merge and create new file from consolidated file.

[@MukeshKala]

Great

[@sharmadeepak9395]

Full of knowledge like always

[@MukeshKala]

Thank You

[@suraj_singh321]

Great video sir can you make a video on transpose row to column where rows are dynamic without using linq query and macro uipath

[@MukeshKala]

Okay , let me try - Thanks

[@suraj_singh321]

@@MukeshKala also for column to row where column are dynamic without linq query and macro

[@dnyaneshkale8293]

Hello sir, thank you for this tutorial. But is there any way to merge(like outer join) two excel files based on single common column? Do you have any tutorial on that?

[@MukeshKala]

I don't have the tutorials but UiPath has the Join Data Table activity which you can use to do Inner , left outer join. So we just read both the data sets into 2 Data tables and apply the Join Data Table activity

[@hemalkansara643]

Awesome

[@MukeshKala]

Thanks :)

[@joshuamarrion66]

Thanks for your video Mukesh it was very helpful 🎉

[@MukeshKala]

Glad to hear that

[@rashmirekha5151]

Hi sir,
Can you please make one vodeo with sql database with exception handling.

[@MukeshKala]

Yes , I can thanks for suggesting

[@David-rm1wn]

Thanks for the video...Where can i get excel sheet file?

[@MukeshKala]

I am yet to uplaode the data to my website - You can drop me a mail on my mailid available in desc and i would revert with file

[@allthecommonsense]

Obsolete. Should be using modern activities and Excel *process* scope

[@MukeshKala]

True , Can be useful for the people where they are in older version of studio (Classic)