Hi
I am trying to use password protected file as input
and i also followed post on the community - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-open-excel-with-a-password/m-p/601428/highlight/false#M134366
But it is giving me error-
I have never worked on R programming and I don't have any idea how it works
Can someone please help me.
Hi @sgaryali
Remove # from the first line install.packages("excel.link") error might be because of the library not found. The first line installs the library.
Hope this helps : )
#1 is the connection name seems like the connection name got changed in place on #1 use #2 in the highlighted place.
Workflow:
thank you for hep but still getting some other type of error
Try this article out.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-The-R-exe-exit-code-n-indicated-an-error/ta-p/741731
Has anyone been able to run this with a .xlsx file, where you need to specify a sheet name?
Thanks
