Import directory with excel password

Question

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"

winnie12 · Answer

@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.

Test Draft.xlsx

mceleavey · Answer

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

M.