I need to fill a column with one specific date. When I use auto fill activity, it fills in a data series even if I provide the first two “source cells” with the specific date.
Example what I get:
Example what I need:
Does anybody have an idea how to do this?
You can use Read Range to read in the data, then use a For Each Row activity to set the value of each cell to the specific value you want. Then use the Write Range activity to set the data in the Excel workbook.
Thanks for your suggestion.
I already thought about this, but I need to do this for around 250 000 rows. I think this will require a lot of time.
Is there any other way to do this?
Have you thought about creating a DataTable with 250,000 rows and then just doing a write-range?
Yes, but then I would have to use for each as well and add a new row with the value 250 times. Or is there another way to create a data table with 250 rows and assign the same value to all rows “at the same time”?
Hi @silvia93, I had the same problem but at the end I used read cell activity to read cell value and then write cell activity where i used the range for example “A1:A10000”
thanks for your answer. That’s a great solution.
Anyway, I already solved it with this workaround:
- write cell activity, e.g. cell B2.
- write formula “=$B$2” in cell B3.
- Auto Fill Range with source cell B3.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.