Hi All,
Please help I have two excel files dt1 has multiple columns in that few columns last row i need find and copy data from dt2 few columns and paste it in dt1
Eg: in dt1 have column name as First Name i need find the last empty row of this column and from dt2 Name column i need to copy the data and paste in the last row on First Name column need to do this for multiple columns.
to find last row you can use find last row activity
then copy paste or write range both can be used
if from excel to excel then use copy paste range
cheers
I need to copy one by one column values from one datatable to another datatable
In Datatable you cannot directly copy paste
you need use add data row add each row
or change column names to source column names and use merge datatable
cheers
@Anil_G Thank you for your help,
I am able to get the solution by doing these steps : Reading the input file and getting the input column using find and replace activity and Read Output file inside passed for each for inputDt and passed find/last row and write cell activity it is working.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.