@@AutomatewithAnmol Yes , In all the subdirectories have 2 excel files, each of the file have 2 sheets. I am looking to merge both the excel files with respect to their respective sheets. Please suggest how it can be done.
@@rohittiwari7019 Unless you do not have the structure, you can't clone it, in case you do it, i think both the datatable would be empty or may even get an error too. After reading the file you have the structure, column names etc., then if you clone it, it works :) or you can do extracteddt = new datatable in variable pane :)
hi i followed ur steps the same way as u did. But getting an error on cloning part. How u assigned mergeddt = extracteddt.clone() before readrange activity. For me its throwing error
This same concept I have done in .net web app. Only diff is how easily with UiPath we can do with less coding. Thanks for sharing 👍
Awesome Video
Thank-you Vikram!
How do I merge two sheets located in separate workbooks to a completely new workbook?
Read two workbooks and store them in two datatables and then you can even opt for Merge Datatable activity.
Can you please share the flow?
I am confused with multiple directory. . .can you make 1 directory please
You have shown how to read data from 2 different sheets but how we can merge and write the data into two different sheets of an output file.
Hi Mayank, So, you want to merge the data and then write the same data in two different sheets? or how it is?
@@AutomatewithAnmol Yes , In all the subdirectories have 2 excel files, each of the file have 2 sheets. I am looking to merge both the excel files with respect to their respective sheets. Please suggest how it can be done.
Hi Anmol
How you have done Mergeddata = Extarcteddata.clone before reading excel file please tell me
The clone is to copy the data table structure without the data. Hope that answers your question!!
@@AutomatewithAnmol yes I know this thing but how you can do it before
reading input file
@@rohittiwari7019 Unless you do not have the structure, you can't clone it, in case you do it, i think both the datatable would be empty or may even get an error too.
After reading the file you have the structure, column names etc., then if you clone it, it works :)
or you can do extracteddt = new datatable in variable pane :)
You can refer the code uploaded here : github.com/Anmol-Yadav/TipsTricks-UiPath
Is any other way to read excel if it exists with same column names??
I think, if we don't include "Add Header Option", then yes.
@@AutomatewithAnmol okay thank you I will try
@@AutomatewithAnmol and one more thing what us the use of parallel activity
hi i followed ur steps the same way as u did. But getting an error on cloning part. How u assigned mergeddt = extracteddt.clone() before readrange activity. For me its throwing error
Hi, you need to do extracteddt = new datatable in variable pane :)
You can refer the code uploaded here : github.com/Anmol-Yadav/TipsTricks-UiPath
HI kindly share the code also so that it can be more helpful waiting for your sooner response
Pls access the code here : github.com/Anmol-Yadav/TipsTricks-UiPath