Unprotect excel workbook

[krishbcd]

Hi,

Is there any way to unprotect excel workbook using UiPath flow?

Thanks,

[Arpit_Kesharwani]

@krishbcd Open protected Excel spreadsheet and SaveAs the file.

[SharmilaSundar (Sharmila Sundaramurthy)]

Hi @krishbcd

Use Atos - Protect and UnProtect File - RPA Component | UiPath Marketplace.

Download the package from the Marketplace using above link and use unprotect File activity by providing FilePath and Password need to unprotect.

Thanks,
Sharmila Sundar

[Airun (Nuria Santos)]

Hi, I’m using the ATOS package to unprotect my excel file, I was thinking that it was ok, but I advised that it’s unrpotecting the workbook structure but not the individual sheets!!

How can we unprotect the sheets?

[balupad14 (Balamurugan)]

Hi @Airun ,

in the below link., you can get protect and unprotect the individual sheets.

BalaReva.Excel.Activities

Hi Friends, 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 [image] Create WorkBook Properties [image] Sample : CreateWorkbook.zip (18.5 KB) Copy To File This activity copies the work sheet to an another excel file. If the another file is not ex…

Regards
Balamurugan.s

[Airun (Nuria Santos)]

Thank you @balupad14 it worked perfectly with this activity!!! This is an awesom package!! Thank you very much!!