Access password protected excel file

[shane6836]

Need to access data in a password protected excel file (it is out file and we have the password) - is there any way to do this (assume it would need to be done with a code element to be able to pass the password)

 

[ArshilAhmad]

Hi @shane6836,

Could you please elaborate a bit more on your exact use case so we can assess its feasibility?

 

[shane6836]

We pull data from different tables in Airtable and use the data to populate the field in Documentero to generate different prefilled forms and documents. Our compliance team have now told us that one specific piece of information that is sensitive for clients cannot be stored in somewhere like Airtable and needs to be more secure. We have moved to a password protected Excel file held in OneDrive.

With the current change, all our automated forms now still need to be manually updated with this one piece of information, so would be great if I was able to search the excel sheet and pull the data, but imagine i will need a way to get through the password each time

 

[Preeti Paryani]

Hello @shane6836

Unfortunately, the use case you are trying to acheive would not be possible.