Appending data in excel

Help Studio
1

I need to download an Excel file from a website on the first day, make some modifications to it, and save it. On the second day, I’ll download a new Excel file from the same website, which will have the same structure but different data. After making the necessary adjustments, I want to append the data from this second file to the original file from the first day.

This process will repeat every day, so on the third day, I will download another file and append it to the main file (the original file from day one). Additionally, once the data has been appended to the main file, I want to delete the newly downloaded files, keeping only the original file intact.\

2

Day 1: Download the Excel File
Use Download File activity to save the Excel file from the website. After downloading, make the necessary changes using Excel Application Scope and other relevant activities. Save the file as your “main” file (e.g., MainFile.xlsx).

Day 2 and Beyond: Download New Excel Files
Each day, download the new Excel file using Download File activity. Open it with Excel Application Scope, make the required modifications, and store it temporarily (e.g., TempFile.xlsx).

Append Data to Main File
Use Read Range to extract the data from TempFile.xlsx. Open the MainFile.xlsx using Excel Application Scope and use Write Range (with the “Add Headers” option unchecked) to append the data from TempFile.xlsx.

Delete Temporary Files
Once the data is appended, use the Delete File activity to remove the temporary files (TempFile.xlsx).

Repeat the Process Daily
Implement a scheduler in Orchestrator to run this process once daily, downloading, modifying, appending, and deleting files as described above.

3

Hi @Tamanna1 Welcome to the forum!

Use the Append Range activity to append the data from the new file to the main file which you can stored as main file
after appending into main file you can use the download file variable and delete that file using delete file activity
End the process. This will run daily and repeat as scheduled.
Please find attached workflow for your reference
Sequence.zip (1.7 KB)

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.