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 destin…

Thank you for your input! What ended up working for me was the following: Use excel file with destination file with reference as exceldest For each file in folder Use excel file with currentfile.fullname with reference as excel Write DataTable to Excel with what to write as excel.currentsheet.Rang…

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

AJ_Ask November 8, 2023, 4:01am 3

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

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

Topic		Replies	Views
Copy folder with Excel files with columns together into a new Excel file Studio	5	311	January 14, 2024
Copy all sheet from one excel to every excel file in one file location / path StudioX studiox , question	1	1043	June 10, 2021
Copy data from Excel one by one Help	15	2916	June 18, 2020
How to copy one sheet in one Excel file to a sheet in another Excel file with UIPATH Studio	10	11039	June 21, 2023
How to copy all different sheets name in one excel file and dynamically create new excel file? Help excel , activities	9	1068	April 18, 2019

Most Active Users - Yesterday
Anil_G
A_Learner
vrdabberu
ashokkarale
Rreddy
Jayesh_678
harshikakhatri269
xdrftww
More details...

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?

Related Topics