Copy and Paste data from multple excel file to one consolidated file

Help StudioX
,
1

Hi,

I have data in 10-20 Excel files which i want to paste in one new workbook consolidated sheet.

I want data to be copied from first excel file with headers and from remaining excel files data should be copied without headers and append it in below the existing data from first excel file.

Please suggest me steps for this…Thank You…!

2

Hello,
Use Read range activity and store them in variable. Make sure to check Add headers in Read Range property.

Use Append range activity and use the variable which is from read range and You will get your data in one sheet.

3

@Dhanad_Prathamesh,

To consolidate data from multiple Excel files into one new workbook in UiPath, you can follow these steps:

  1. Read Excel Files: Use the “Excel Application Scope” activity to open each Excel file one by one. Inside this scope, use the “Read Range” activity to read the data from each sheet.
  2. Combine Data: After reading data from each Excel file, store it in a DataTable variable. Then, use a loop to combine all DataTables into one consolidated DataTable.
  3. Write to New Workbook: After consolidating the data into a single DataTable, use the “Excel Application Scope” activity again to create a new Excel workbook. Inside this scope, use the “Write Range” activity to write the consolidated DataTable to a new sheet in the new workbook.

Thanks,
Ashok :slight_smile: