I need to copy from B1 to C55 from one excel and paste it in new excel
Hi @sruthesanju
steps to be followed
- read range (Give your range)
- Write Range in the destination excel (i.e, New Excel )
Note : I have used Workbook activities
If you use Excel Activities you need to use inside "Excel Application Scope " Activity
If you need to copy a entire column from one excel to other
Follow the steps
- read range (Give range as “”)
2)Use Filter Datatable and refer the screen shot for steps(Store in the new datatable variable)
- Write Range
Datatable: The new datatable created in Filter datatable .(i.e DT2)
Path: The New Excel file in which you need to add the column
Regards
Sudharsan
Hi
Let’s make it in a simple method
-
Use a excel application scope and pass the file path as input and use read range activity where mention the range as
“B1:C55”
And enable or disable add headers property based on your requirement
And get the output as dt - datatable variable -
Now next to excel scope activity use a WRITE RANGE activity from Workbook activities
Search as workbook in activity panel and get write range
In that mention the input as dt
And mention the range you want or leave it empty which will write from “A1” and enable or disable add headers as per the need
That’s it
You are done
Hope this would help you resolve this
Cheers @sruthesanju