Input protected password "Error: Bad Variable"

Question

Hi all,

I've been using the workflow provided in this link:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-open-excel-with-a-password/td-p/601415

However, when running it, the attached error message appears "Error: Bad variable type."

I have checked the data type of my password, it is V_String" like in the workflow.

leozhang2work · Answer

A bit of old post to comment, but as I am currently doing same thing, I will respond to it.

The initial reference to https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-open-excel-with-a-password/td-p/601415 should work fine.

I've got the same error, turns out I named by column names wrong.

For yours, I guess try to drop write.res.password if you don't have a second password for editing (or different one)

For the later pictures, try to drop lapply and as.data.frame first to see.

My guess is lapply casted it to a list, then a data frame probably convert it without header, hence the error.

apathetichell · Answer

I think it might be an issue with the underlying package - I implemented it in a test case. Worked fine with no protection. Worked fine with some protection. The more protection options I used the more errors popped up. I haven't had the time to see if it's re-creatable outside of Alteryx as an error or if the error is Alteryx/output specific.

charlottepetit · Answer

Done, no change to the output unfortunately. I'm thinking it might have something to do with the formula xl.read.file?