Import directory with excel password

[winnie12]

Hello, 

I've try to import directory that contain many excel file that have lock with the same password. and excel file include many sheet but i would to import data only one sheet in each excel file. Do you have any solution. please help to advise.

I've attached sample excel file with password "alteryx" and I would to import data from sheet name "SellIn1" 

[mceleavey]

Hi @winnie12 ,  you haven't attached the file.

M.

[winnie12]

@mceleavey > It was show "The attachment's draft file.xlsx content type (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet) does not match its file extension and has been removed." when i try to upload file with password protect. However, I've upload format file only. Could you help to do password protect then advise alteryx workflow for dynamic input file with release password protect. I've file format like attached around 20 file with the same password protect.