Log in to AnswerLog in to Follow
Emman Si
54Views
9Comments
Solved
Import password-protected excel file
Question
Import/Export Data

I am trying to import an excel file that requires a password to be opened, but I am getting the error "File contains corrupted data."


I found in the documentation that encrypted file cannot be imported in here. Is a password-protected file what it meant as encrypted?


If that is the case, do we have an alternative to import such excel files?

0
0
on 2020-08-07
Emman Si
Solution

Hi All,

I have resolved this issue by exposing a method from EPPlus library which is not present, last time I checked, on the component exposing said library.

Since a snippet would be too long as text, here is an image of my implementation.


Hope this helps!

Cheers!

Emman

See solution in context
Capture.PNG

0
0
on 29th Mar
Daniël Kuhlmann
mvp_badge
MVP

Hi Emman,

The Forge component https://www.outsystems.com/forge/component-overview/355/advanced-excel has functionality to handle sheet and workbook protection.

Regards,

Daniel

0
0
on 2020-08-07

Hi Daniel,


I checked that component, but from what I can see it has the functionality to create excel with protection. I don't see an action there that allows for reading such files.


Cheers,

Emman

0
0
on 2020-08-08

Hello Emman SI,

Does you got any solution about the same?

0
0
on 23th Mar

Hi Emman Si

I'm afraid that if you want to import that file or any encrypted file you need to remove the password first.

Regards

Gonçalo Almeida

0
0
on 23th Mar

Hello @Goncalo Almeida - Even though if file level password is removed. excel binary is not getting uploaded.

Follow below forum discussion as i have raised last week.
https://www.outsystems.com/forums/discussion/69386/advanced-excel-uploading-encrypted-excel-file-in-outsystems-using-reactive/ 

0
0
on 29th Mar

Hi,

Unfortunately, it's not possible to upload and read encrypted excel files on the platform.

To use the file you need to remove the encryption.

Hope it helps,

Ricardo Pisco.

0
0
on 29th Mar
Emman Si
Solution

Hi All,

I have resolved this issue by exposing a method from EPPlus library which is not present, last time I checked, on the component exposing said library.

Since a snippet would be too long as text, here is an image of my implementation.


Hope this helps!

Cheers!

Emman

Capture.PNG

0
0
on 29th Mar

Hello @Emman Si So have this implemented in advance excel component? or have this feature is published?

0
0
on 29th Mar

Hi Pavan,

I have not checked Advance Excel thoroughly in a while, but from what I can see it seems not yet.

I integrated and used EPPlus library directly through Integration Studio and defined the action myself.


Hope this helps!

Cheers!

Emman

0
0
on 30th Mar
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.