How to copy the entire workbook in UiPath?

Hi UiPath,

I need help with my automation.

Lets say I have a workbook file named SAP VS Cashflow and it contains 3 sheets below:

image

I want to copy all of it and preserve all the formulas in this workbook.

How can I do that?

Read range activity can only specify 1 sheet name however in my case I need the 3 sheets.

Can someone help me?

Advance thanks!

AA

Hi,

How about CopySheet activity?

Regards,

@aapostol you can also iterate through sheet names inside an Excel Application scope. Here is an example:

READ_MANY_SHEETS.xaml (9.4 KB)

Hope it helps.

1 Like

Hi @aapostol

Please try copy file activity it will copy the file and paste as new file,

https://docs.uipath.com/activities/docs/copy-file

Thanks