I have included the below new custom components in the package.
1.Create Workbook.(Create a new worksheet)
2.Copy to File (Copy the worksheet to another excel file).
3.Copy to WorkBook (Copy the worksheet inside the workbook).
4.HideUnhide the worksheet
5.Protect Unprotect the worksheet
Sample : CreateWorkbook.zip (1.3 KB)
Copy To File
This activity copies the work sheet to an another excel file. If the another file is not exists, you can set the property “Auto File Creation” = true. It creates the file automatically and copies the worksheet.
Sample : CopyToFile.zip (119.6 KB)
Copy to Workbook
If you are not provide value to the “New Sheet Name” property. It will add the default worksheet name(Sheet1).
sample : CopyToWorkBook.zip (119.6 KB)
HideUnhide (It hides and un-hides the worksheet in the work book)
Sample :HideUnhide.zip (8.1 KB)
Protect UnProtect (It protects and un-protects the worksheet with password )
Sample: ProtectUnProtect.zip (8.2 KB)
Let me if you have any errors.
I would be happy to get more suggestions.
The samples are developed by UiPath Studio version : 2018.3.0-beta.1