Password Encryption

[Inactive User]

Good Morning All,
I need to encrypt a password for an output - can anyone guide me with a simple workflow to create a password for excel or PDF files ? Thanks in advance for your guidance.

Regards,,

Guru

[BrandonB]

You could use a Python script after the file is created doing something like this: https://stackoverflow.com/questions/43475295/encrypt-pdfs-in-python 

[Inactive User]

Hello @BrandonB - I dont have python application.
Is there any way to create a macro wherein i can create a password for XLSX (Excel) and PDF's in Alteryx tool ?

[BrandonB]

@Inactive User there is a python tool within Alteryx: https://help.alteryx.com/20214/designer/python-tool 

You can read data into this tool as a dataframe and perform the actions that you are looking to accomplish

[Inactive User]

Hello @BrandonB 

I used below python code - but resulting with an error as invalid syntax. Kindly review and advice. Thanks ! 

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, xl.sheet = "sheet1", password = excel_pwd)
write . res . password = excel_pwd )
write.Alteryx output <- lapply(excel_data, as.character)
output <- as.data.frame(output)
write.Alteryx(output, 1)