I have an Excel file and want to copy the sheet to an Excel file which doesn’t exist yet and has to be created by the Copy Sheet activity. The good thing is that the file is generated but it is empty. Just the name is true. While I run the process I see that the new Excel file is being filled and closed after that. When I open it again it is empty as I said. Why does that happen and how can i solve it? I need the exact same sheet with the data and how it is formatted.
Every help is appreciated.