Can you please help me solve this problem, i have to copy and paste an excel sheet in another one guarding the same style and format, it doesn’t work with hotkeys : Ctr+C , Ctrl+V neither with click copy + click paste .
Welcome to the Community!!!
Use Copy To File activity to copy the work sheet to an another excel file. If the another file doesn’t exist, you can set the property “Auto File Creation” = true. It creates the file automatically and copies the worksheet.
hello, i don’t want to copy the whole file , i want to paste one of the sheets of the excel file.
Copy file copy all sheets
This Copy to File activity is customised activity and you can copy the excel sheet to another file.
If you’re not able to find this in studio, please refer to below post for an alternative:
You can also Use VBA OR Macro to copy the entire sheet with its format in same workbook or in another workbook.
it wouldn’t work with an existing file, il copies in a new excel file, it may be because of excel version
Error message :
Main has thrown an exception
Source: Copy Sheet
Message: That name is already taken. Try a different one.
Exception Type: COMException