How to Append Daily Data to a File Using UiPath Automation? (creating a cumulative log.)

[jaeho_hyeon]

Hello UiPath Community,

I am currently working on a project where I need to use UiPath to automate the process of collecting range data and saving it to a file. My goal is to run this automation daily, and I want each day’s data to be appended to the file below the data from the previous day, effectively creating a cumulative log.

Could someone guide me on how to structure the activities in UiPath to achieve this?

For example, it is as follows.

As shown in the table above, a cumulative log of data obtained every day is created by day. If today is 7/24, it is a method of entering values in the lower row of 7/23.

Thank you very much for reading. Hope you have a great day.

[mkankatala (Mahesh Kankatala)]

Hi @jaeho_hyeon

Do you want to append the data to the previous date data or as you said below the 7/23 or 7/24 like that we are unable to see 7/24 in the attached image.

[ashokkarale]

@jaeho_hyeon,

Use Apend Range activity.

Thanks,
Ashok

[jaeho_hyeon]

Thanks for your question!
I’m trying to add some random data that I can extract on 7/24 to the above table under 7/23.

[mkankatala (Mahesh Kankatala)]

Okay got it… @jaeho_hyeon

After extracting your data, it is coming by datatable, right? Then use the Append Range workbook activity to append the data to the existing Excel file.

Append Range workbook Activity - This activity will help us append the rows to the existing rows in the Excel file.

Hope it helps!!

[jaeho_hyeon]

Thank you so much for your reply! That activity is something I didn’t know about, I’ll give it a try.
Have a nice day!