How to import data from a password protected excel

[Vidya Sagar Mis]

Is there a was to upload data from a password protected excel sheet?

I need to create an inbound email action which will import the data from attached excel sheet. However the file is protected using a pre-defined password.

Kindly Suggest!

Thanks

Sagar

[Sukraj Raikhraj]

Found this from an older HI support article:

Proceed with Cautious.

After carefully reviewing this incident and looking for a workaround, unfortunately the only fix currently now to bypass password protected files on to your instance is through setting the 'glide.security.file.mime_type.validation' to false. There is currently no other way to bypass this. If you would like this functionality of bypassing password protected attachments without having to set the 'glide.security.file.mime_type.validation' false, the only way is to go down the implementation or customization route.

[Vidya Sagar Mis]

Thanks Sukraj,

I am looking for importing data from password protected excel sheet however the solution is about uploading the password protected files as attachment.

Thanks!

[Sukraj Raikhraj]

Correct, I believed the file will have to be uploaded as an attachment before it can be parsed by SN so that why the recommendation is to ignore the mime type check,  you can tried it on your dev instance..