There are times that you want to read in Microsoft Excel files that have been password protected without going through too many extra hoops. Out-of-the-box the INPUT Tool will not do this - 2019.2 included. But you are in luck there are numerous R & Python packages that can handle this request. Here is one example leveraging the R Tool.
Workflow to read in a password protected Excel file.
Attached below is the workflow, but if you just want the R code then here you go. (notice that library that needs to be installed)
# install.packages(c("excel.link"))
library("excel.link")
df <- read.Alteryx("#1", mode="data.frame")
filename <- as.character(df[1,"FullPath"])
excel_pwd <- as.character(df[1,"excel_password"])
excel_data <- xl.read.file(filename, password = excel_pwd, write.res.password=excel_pwd)
write.Alteryx(excel_data, 1) 
