How to take screen shots excel work book sheets

[T_Y_Raju]

Hi
i have requirement i have 5 excel sheets in excel workbook i want to take screenshots of all the excel sheets and paste back in another excel sheets
any idea how can do

[esraa_elzoghby]

Hey @T_Y_Raju

You want to copy the the 5 sheets and paste them into another sheets?
if yes, you can do the following steps for each sheet:

• Use “read range” activity to copy the sheet in particular data table.
• Then use “write range” activity to paste it into the new sheet.

Do this steps five times, so you will add five “read range” activities and five “write range” activities, in each one of them you have to change the source sheet and the destination sheet.

Hope it helps, let me know if it works.
My regards.

[Yoichi]

HI,

Hope the following sample helps you.

Sample20221108-1.zip (21.6 KB)

Regards,