Excel copy worksheet not work

[jackyaa1 (Jacky)]

I try to copy the worksheet to a new worksheet. The output results only one worksheet. I saw the uipath have copied the worksheet during the program running, but the output file only having one sheet. Is there any activities I need to add to save the excel correctly.
I don’t know what do I doing wrong. I faced same issues on create pivot table, the pivot table format also missing…
table.zip (2.8 KB)

[ghazanfar (Ghazanfar Ali)]

You can modify your code like this. Read sheet01 with read range and store it into Sheet01DT.
Then use write range activity and pass the same excel workbook path and pass sheet01DT into datatable field like below. Use first two activities see in the screenshot.