Output to Password protected Excel File

Question

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.

Sameer_Kanade8810 · Answer

Hey Ricardo,

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

geraldo · Answer

@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