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.

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

I used write cell, but it writes from the beginning.

@momo10 Use append range outside the loop


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.

     rowCount = dtInput.Rows.Count+1
  3. And use your flow to read the pdf filename and then use Write Cell activity and pass below parameters to it.

    Range: “B”+rowCount.ToString
    Value: strInitFolderName

i did as you described, but fukionnert not

it’s not working