How to use write cell excel activity dynamic in For each row

Learning Hub Academy Feedback
, ,
1

Dear All
how i can use Write cell activity
i read the sheet in data Table then i Append range then i want to copy data from Column C to This new cloumn i used writhe range but it’s very slow due to to much data i want to use Write cell to be fast but it’s not working with me

Screenshot999
Screenshot999555×729 19.8 KB
Screenshot99999999999999
Screenshot99999999999999555×610 13.1 KB

2

Screenshot8888888
Screenshot8888888707×628 13.7 KB

3

Hi @Mohamed_Abbas

You could use counter here to increase cell number dynamically.

Please refer below post-

Thanks,
Shilpi

1 Like
4

thanks for your replay
your idea is right if you want to copy past between two Sheet
for my case i want create new column in same sheet (Apeend Range ) and copy Column C and past to this New Column this will be in the Same sheet
thanks

5

Hi @Mohamed_Abbas,

You can do it with auto fill option in excel.
1.Read the excel file in excel application scope.
2.Find the last row number by assigning datatable.Rows.Count +1
3.Write the first cell with value “=Cell id”(from which cell you want to copy)
4.Use select range activity to select the cells, in which you need the copied values.(Range-“first copied cell id:last cell id”)
5.Use ‘Send HotKey’ activity to pass the hotkey “Ctrl+D” to fill the values in the excel table.

Please see the workflow. copy_column.xaml (8.2 KB)
copy_Cell test.xlsx (8.0 KB)

Warm regards,
Nimin

6

Screenshot66666666666666666
Screenshot666666666666666661911×817 122 KB

dear All this i want to do copu column C every day and paste in new column with today date as header

thanks All