Require a help in a scenario.
I need to work on a excel file which is password protected file. I want to unprotect it first to read it, thus but I do not want to use Excel application scope password properties for that due to some constraints.
Either options which I am thinking of are VBscript(need one)/macro.
any help would be appreciated.
@supermanPunch @ppr @Srini84 @balupad14 @THIRU_NANI @ashwin.ashok @Gokul001 @nikhil.girish can you guys suggest something
@Shikhar_Tandon , Can you check this?
Hi there !
I’m already blocked at the very beginning of my bot creation as the excel files I have to copy are protected and it seems it generates some error messages
Does someone has any hint to share on which actions assign to the bot ?
Thanks for this, I dont want to go with the activity approach as the file I am reading can be greater than 200 mb in such cases the activity will not work.
@Shikhar_Tandon , even if you go by “either options” you still have to pass the credentials to access and process the file. so what is the harm in using the activity to simplify your automation?
@Shikhar_Tandon Please refer to the below thread
Please refer the below post.
Actually as the file is very large in cases, I am using UiPathTeam.XLExcel.Activities to access the file but this package does not give flexibility for password compatibility thus i need some Vb or anything by which I can access the file providing the password then will use UiPathTeam.XLExcel.Activities->Read range activity to read the file.
Have you checked this video?
Thanks for this, whereas in this video is referring to protect/unprotect Sheet. My problem is with the file
The file lock is done by File->Info->Protect File.
can you try this buddy
and later execute macro from uipath
Thanks a lot for you inputs!!
Whereas I cannot perform these steps on clients worksheet data
. They will not agree for this
Check below link for your reference
If you can’t use the activities which are available in UiPath then you need to use Invoke Code activity and write your own code
Check above for the code snippet
Hope this may help you
Could you try the Below Workflow :
Excel_RemovePasswordProtection.xaml (6.8 KB)
Interop.Excel to Remove the Password Protection from the file. You should then be able to use the
XLExcel.Activities to read the file.
Let us know if it doesn’t work.
That works perfectly, only one thing as the file is unlocked post reading the file I want to again password protect it. Can you tweak in the above code and help on that as well.
Is there any way too to disable the popup(the Automatic update links popup) using interop as while protecting it is appearing in between and as the file is not owned by me i cannot request the owner to disable that.
Generally, we would ask you to Open another Topic for this Purpose.
However, I do think there needs to be some Excel Settings that need to Configured for the Popups to be Disabled, as I have experienced as well. But do Check by adding one line in the Invoke Code :
If it doesn’t work I would think the only way Might be to change the Excel Settings, maybe create a New Topic, so People Could Suggest Better Solutions :
How can one avoid Excel link update popup?
Issue Description : When Robot tries to open Excel file, it shows a pop-up : "This workbook contains links to one or more external sources that could be unsafe". How can this pop-up be avoided ?
Pop-up Screenshot :
Resolution : This message is a Security Warning that Automatic update of links has been disabled.
To suppress the message and to automatically update the links when you open a workbook, follow these steps:
Yes, I am aware of this. Whereas Thanks !!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.