Write to cell in for each row

Learning Hub
,
1

Hello, I am trying to add a static string to all data rows in column A of my data table.

example3
example3916×616 16.6 KB

I have about 15 000 data rows and I am using the for each Activity and a Counter but it is taking an average of 5 seconds to write to each cell. Is there a faster way to do this because it might take hours to write to all the cells in the column.

Regards

2

U can use Assign
Row(0)=“11/05/2020”
At the end of for each row use write range

3 Likes
3

Other Way is U can use
Write cell for A2
then use

AutoFill Range

Source = “A2”
Destination= “A2:A”+(DT.rows.count+1).Tostring

4

Should it be Row(0) or Row(Counter)?

5

As You want For A Column thats why i used Row(0)
Indexing is start from 0th
so A column will be 0th
So if u want to write it in B column then use Row(1)

1 Like
6

Thank you, it works but still takes qiute a bit of time. It took 20 minutes to write to 15 500 data rows. But its definitely better than it was before. :slight_smile:

7

Your most welcome :blush:

Happy Automation!

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.