# Write Data into excel using iterate value

**URL:** <https://forum.uipath.com/t/write-data-into-excel-using-iterate-value/143712>\
**Category:** Academy Feedback\
**Tags:** excel, activities\
**Created:** [August 21, 2019, 5:50am UTC](https://forum.uipath.com/t/write-data-into-excel-using-iterate-value/143712 "2019-08-21T05:50:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arun\_Pondhe](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/arun_pondhe/32/91478_2.png) [@Arun\_Pondhe](https://forum.uipath.com/u/Arun_Pondhe)\
**Post date:** [August 21, 2019, 5:50am UTC](https://forum.uipath.com/t/write-data-into-excel-using-iterate-value/143712/1 "2019-08-21T05:50:36Z")

</div>

How to write iterated data into column-wise into excel…

---

<div class="post-metadata">

**Author:** ![AshwinS2](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ashwins2/32/176686_2.png) [@AshwinS2](https://forum.uipath.com/u/AshwinS2)\
**Post date:** [August 21, 2019, 5:55am UTC](https://forum.uipath.com/t/write-data-into-excel-using-iterate-value/143712/2 "2019-08-21T05:55:55Z")

</div>

Hi @Arun_Pondhe  
Use Build datatable activity  
use for each row in Dt  
add data row {}  
use output datatable  
use write range

Thanks  
Ashwin S

---

<div class="post-metadata">

**Author:** ![HareeshMR](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/hareeshmr/32/181825_2.png) [@HareeshMR](https://forum.uipath.com/u/HareeshMR)\
**Post date:** [August 21, 2019, 12:07pm UTC](https://forum.uipath.com/t/write-data-into-excel-using-iterate-value/143712/3 "2019-08-21T12:07:05Z")

</div>

You can do that as @Arun_Pondhe

1. Create a integer value and assign it with 1 assuming as count
2. While iterating the data, use write cell activity and give the range as “A” + count.tostring
3. Increment the value as count = count + 1 using assign activity