Hello People out there....
Hope all is fine and well at your end.
I have a blocker using advance excel component using in outSystems 11 Reactive web development as follows below:
1. I have a functionality to upload excel file, read all the columns/row data and show in the accordion.
2. If I upload w/o password protected excel file, it is getting uploaded without any issue.
3. But if I upload password protected excel file, it shows below error. (This feature I needed as per my business requirements)
4. When using advance excel component. It does not have any method from which it could read a password from imported excel file.
5. Do you help me out here by sharing your thoughts?
HI Pavan Suthar Jethmal
It's not possible to import an encrypted file.
You can check here: https://success.outsystems.com/Documentation/11/Reference/Errors_and_Warnings/Errors/Invalid_Excel_Import_Error
Regards
Gonçalo Almeida
Thanks for your input @Goncalo Almeida . I was checking out for solutions across forum.
Hi Pavan
Do you have the password for the excel file?
Yes Hanno. I have a password for opening excel file.
I see it is not currently supported by the component. Shouldn't be too hard to add in if someone wanted to. I'll see if I can manage to do so somewhere this week or the weekend.
That would be great Hanno.Thanks a ton if this would get implemented through code.
HannoI would future like to add that is, for any excel file, there are different password level protection, example for worksheet or opening a file.Would need to see if all those below highlighted gets covered under same version if codes gets deployed.
info setting view in excel file
Hi there,
I have the same problem. How to work around? thanks
Hi, All
Any solution for this?
Hi Mohammed
Have you tried with the latest version of the component?
I believe it already supports opening an Excel file that is password protected.
Hanno
Hi @Hanno
Thanks for the quick reply
I tried with the newer version but not able to find anything related with this can you please help.
Thanks
Rizwan
It seems I was remembering incorrectly, my apologies! The functionality has not been added yet.
Just wanted to check the feature is implemented in component or still in progress
can you please confirm