Copy excel sheet

[yogitagaikwad2206]

copy data from one excel name sheet A and paste in other excel sheets like Sheet AB, Sheet BC, Sheet CD, Sheet DE, Sheet EF

how i do it?

[lchirathapudi (Pallavi Chirathapudi)]

Hi @yogitagaikwad2206

Try this

Array_SheetNames={"SheetAB","SheetBC","SheetCD","SheetDE","SheetEF"}

Sequence8.xaml (11.3 KB)

Regards,

[pravallikapaluri]

@yogitagaikwad2206

As you mentioned there are 2 excel file need to use two Use excel file activities

[yogitagaikwad2206]

right i have 2 excel files but in second excel have 5 sheets and i want to paste same data in all 5 sheets, so i wan to take 5 copy paste activities?

[lchirathapudi (Pallavi Chirathapudi)]

@yogitagaikwad2206

In that case try below

Sequence8.xaml (13.2 KB)

Regards,

[pravallikapaluri]

@yogitagaikwad2206

Use 5 copy Paste range activities.
Source is same
Destination is different

[yogitagaikwad2206]

I already done this but it takes too lang time
Can I do read excel file and pass data table in write range of all 5 sheets

Because it copy again & again may it takes time

[pravallikapaluri]

@yogitagaikwad2206

[pravallikapaluri]

@yogitagaikwad2206
Read the excel once and store in the datatable.
Store all the sheetNames in a array
Pass the currentText into WriteRange of foreach

Hope it helps!!

[pravallikapaluri]

@yogitagaikwad2206
Did you got solution??