Output to Password protected Excel File

[ricardo_takimoto]

Hi, I already found many posts on how to create password protected excel files, however, what I need to do is update the sheets of an already existing password protected excel file using Alteryx. When I use the Output Tool selecting the protected file I get the error "Unable to read for write", so for now I've been outputing my data to an unprotected file and pasting it on the protected one. Is there a way to output directly to the password protected file?

Any help is appreciated.

[geraldo]

@ricardo_takimoto 

You can use r tool and python tool. The 2 languages ​​support you to manipulate protected excel. Do a search R= excel, link python has several libraries

[Sameer_Kanade8810]

Hey Ricardo,

you can create a cscript vba macro which will unprotect the file for you before appending the data to the output file.