aapostol
(Aapostol)
1
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:

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
Yoichi
(Yoichi)
2
Hi,
How about CopySheet activity?
Regards,
dokumentor
(Gabriel Marin)
3
@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
prasath_S
(prasath S)
4
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