How to store all the data using write range when I am trying to add new data it's replacing old data

[kavitha_chavala]

I am storing details using datarow and add datarow activities

[kavitha_chavala]

Pls someone help me in this

[monsieurrahul (Rahul)]

Hi, try using Append Range instead of Write Range activity.

[kavitha_chavala]

It’s removing column names if I use append range and also Its entering same column with different row. I need to store based on dates

[kavitha_chavala]

I need data like below image with based on user input

[kavitha_chavala]

I written like this using if comdition

[jast1631 (Jagravi Trivedi)]

In the data row property
Instead of data row
Pass your row to array property by
Rowname.itemarray @kavitha_chavala

[Kismet_Tosun (Kısmet Tosun)]

Hi, @kavitha_chavala

It can be help to you.

Example:
Data.xlsx (10.3 KB)
Main.xaml (19.1 KB)

[Anil_G (Anil Gorthi)]

@kavitha_chavala

I feel build datatable is present inside for loop

please move it outside the loop

cheers

[kavitha_chavala]

I did not use for loop even

[Anil_G (Anil Gorthi)]

@kavitha_chavala

okay then ideally you need to use append range if old data should not be overwritten

or in write range when already data is present…first read data …coutn rows and then add write range leveraging the count and adjusting the range property

cheers