I am using uipath studiox. I am trying to copy the same range from 15 different spreadsheets, and post them to the same destination. How can I build a automation for this?

Help StudioX
, , ,
1

I am trying to create a automation to copy the same range from multiple spreadsheets, and paste them into a destination excel file. For example each source spreadsheet I will be copying the data from cells A2:W2, how can I copy those ranges for multiple spreadsheets and paste them to the same destination excel file?

2

I highly recommend going through all the free training on the UiPath Academy web site.

3

Check this link out where I have already answered the question along with the flow. Hope this helps :slightly_smiling_face:

https://forum.uipath.com/t/open-excel-files/683895

4

@jason.patrick

Follow the steps

  1. Use excel fiel with destination file with reference as exceldest
  2. For each file in folder
  3. Use excel file with currentfile.fullname with refereence as excel
  4. Read range inside use excel file activity with excel.currentsheet.Range("A2:W2") and save output to datatable dt
  5. Append range with dt as input and range as Exceldest.currentsheet

Cheers

5

In step#4, how can I save output to data table?

image

6

@jason.patrick

Clcik on plus and select a variable or create one

Cheers

7

Thank you for your input! What ended up working for me was the following:

  1. Use excel file with destination file with reference as exceldest
  2. For each file in folder
  3. Use excel file with currentfile.fullname with reference as excel
  4. Write DataTable to Excel with what to write as excel.currentsheet.Range(“A2:W2”), Destination as the destination file
8

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