# Help!

**URL:** <https://forum.uipath.com/t/help/413389>\
**Category:** Robot\
**Tags:** datatable, question, robot, excel, activities\
**Created:** [April 7, 2022, 10:13am UTC](https://forum.uipath.com/t/help/413389 "2022-04-07T10:13:03Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![momo10](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/momo10/32/263910_2.png) [@momo10](https://forum.uipath.com/u/momo10)\
**Post date:** [April 7, 2022, 10:13am UTC](https://forum.uipath.com/t/help/413389/1 "2022-04-07T10:13:03Z")

</div>

hello all,  
I am trying to count many pdf files into many folders and write them into an excel sheet. I don’t want to start from the beginning but from n-number. the question is, I have automated this with RemoveRows but it doesn’t write it into the exact place but starts from the beginning.  
Can you help me.

 ![Unbenannt1](https://global.discourse-cdn.com/uipath/original/4X/7/1/b/71b621ce0a27b76b90ff802ac1db442d1d4b334d.png)  
 ![Unbenannt](https://global.discourse-cdn.com/uipath/original/4X/3/9/b/39b6b81c6a0db43db31eaa5f54b1c6f4e91f8444.png)

---

<div class="post-metadata">

**Author:** ![indra](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/indra/32/34761_2.png) [@indra](https://forum.uipath.com/u/indra)\
**Post date:** [April 7, 2022, 10:16am UTC](https://forum.uipath.com/t/help/413389/2 "2022-04-07T10:16:26Z")

</div>

@momo10 Use append range activity which inserts data to last row.

---

<div class="post-metadata">

**Author:** ![momo10](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/momo10/32/263910_2.png) [@momo10](https://forum.uipath.com/u/momo10)\
**Post date:** [April 7, 2022, 10:26am UTC](https://forum.uipath.com/t/help/413389/3 "2022-04-07T10:26:01Z")

</div>

> [@indra](#):
>
> Use append range activity which inserts data to last row.

I used write cell, but it writes from the beginning.  
 ![Unbenannt3](https://global.discourse-cdn.com/uipath/original/4X/e/0/3/e03c6cf810e878b9ac51d3f966c1ed51b7886f69.png)

---

<div class="post-metadata">

**Author:** ![indra](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/indra/32/34761_2.png) [@indra](https://forum.uipath.com/u/indra)\
**Post date:** [April 7, 2022, 10:27am UTC](https://forum.uipath.com/t/help/413389/4 "2022-04-07T10:27:14Z")

</div>

@momo10 Use append range outside the loop

---

<div class="post-metadata">

**Author:** ![lakshman](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/lakshman/32/523490_2.png) [@lakshman](https://forum.uipath.com/u/lakshman)\
**Post date:** [April 7, 2022, 10:32am UTC](https://forum.uipath.com/t/help/413389/5 "2022-04-07T10:32:53Z")

</div>

@momo10

Follow below steps before that flow.

1. First use **Read Range** activity to read the data from Excel file and it will give output as DataTable. Let’s say **dtInput**.

2. And then find out DataTable row count as below.

3. And use your flow to read the pdf filename and then use **Write Cell** activity and pass below parameters to it.

---

<div class="post-metadata">

**Author:** ![momo10](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/momo10/32/263910_2.png) [@momo10](https://forum.uipath.com/u/momo10)\
**Post date:** [April 7, 2022, 11:24am UTC](https://forum.uipath.com/t/help/413389/6 "2022-04-07T11:24:09Z")

</div>

i did as you described, but fukionnert not  
 ![Unbenannt5](https://global.discourse-cdn.com/uipath/original/4X/2/2/8/22846cc26d7ad677e511b9685641781cdfab870b.png)

---

<div class="post-metadata">

**Author:** ![momo10](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/momo10/32/263910_2.png) [@momo10](https://forum.uipath.com/u/momo10)\
**Post date:** [April 7, 2022, 12:00pm UTC](https://forum.uipath.com/t/help/413389/7 "2022-04-07T12:00:39Z")

</div>

it’s not working
