Copy data from different Excel sheets to another excel

Help Activities
1

In Excel 1 , I have 4 sheets .How to copy all the sheet1,3 into another excel.
How to set range in that

2

Hi

If u want all the sheets of excel which means a copy of excel file then we can simply create a copy with COPY FILE ACTIVITY

https://docs.uipath.com/activities/other/latest/workflow/copy-file

Or

If u r looking to create another excel with limited sheets then do the same like above with copy file activity, create the file and then remove the sheets with DELETE SHEET activity

https://docs.uipath.com/activities/other/latest/productivity/delete-sheet-x

Cheers @anjani_priya

3

I want the data from 3 sheets of Excel to single sheet of another excel

4

Hope all the sheets have same set of columns
If yes then you can merge all sheets
Check this out

@anjani_priya

5

No not like this
The sheets should be printed downwards

6

@anjani_priya

hi
try this

cheers

7

@anjani_priya

Follow the steps

  1. Use excel file with the excel containing 3 sheets
  2. Use for eachs heet inside it
  3. Use read range inside for each and then save data into datatable dt
  4. Use merge datatabe activity and merge dt into mergedt datatable
  5. Outside the loop and ise excel use a write range qctivity and give the datatable as mergedt

Cheers

8

iam getting an error that object cant be change to datatabale

9

@anjani_priya

Can you please show where you are getting it?

Cheers

10

excel task1.xaml (13.0 KB)
this is my code.I want only 3 sheets from excel which contain 10 sheets and that sheets should paste one after other downwards in other excel

11

Can you provide the sample data of your excel…

@anjani_priya

12

NO I CANT GIVE.
EXAMPLE- IF I HAVE DATA IN 1-2000 ROWS I HAVE TO DELETE 7 TH ROW AND 1023TH ROW LIKE WISE HOW

13

@anjani_priya

Is your requirement to delete or copy?

If copy specific sheets then temove for each sheet and add for eqch with names of sheets as list …and use currentItem to get each sheet

If delete let me know what is the criteria…then can write linq or filters

Cheers