How to copy the excel file when downloading from web

Help Activities
, ,
1

That is, I can download an Excel file from the web and use it, let’s say it’s yesterday’s statement. Then I will take the rows from row A2 to the last row, which I don’t know how many rows, and put them at the end of Excel that has collected each day’s statements. Which command should I use? What are the keys?

2

@Sarttra

Welcome to the community

  1. Use read range activity to read whole of the data of new file into datatable
  2. Use append range activity to append the read data into already present file

The above two are excel activities which will hep you in this task

Hope this helps

Cheers

3

Hello @Sarttra

  1. Download the Excel File from the Web:
  • Use the “HTTP Request” activity or “Download File” activity to download the Excel file from the web. Make sure to provide the URL of the file.
  1. Read the Downloaded Excel File:
  • Use the “Read Range” activity to read the data from the downloaded Excel file into a DataTable. This will allow you to work with the data in UiPath.
  1. Read the Existing Excel File:
  • Use the “Read Range” activity to read the data from the Excel file where you collect each day’s statements. Read this data into another DataTable.
  1. Append Rows:
  • Use the Merge DataTables activity to append the rows from the downloaded Excel file to the DataTable containing the existing statements.
  1. Write Data Back to Excel:
  • Use the “Write Range” activity to write the merged DataTable back to the Excel file where you collect daily statements. Make sure to specify the starting cell where you want to append the data (e.g., A2).
  1. Save and Close Excel File:
  • Use the appropriate activities to save and close the Excel file.

Thanks & Cheers!!!

4

Can you please explain in detail what I should fill in?

5

@Sarttra

  1. Download Excel File (HTTP Request)
  2. Read Excel Data (Downloaded File) (Read Range)
  3. Read Existing Excel Data (Read Range)
  4. Append Data (e.g., using Merge DataTable or manual iteration)
  5. Write Appended Data to Excel (Write Range)
  6. Close Excel Application (Excel Application Scope + Close Workbook)