Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

I am trying to write to a password protected excel using the R tool but getting errors.

AkisM
10 - Fireball

Hi all,

 

"Error: R (4): Error in xl.write(r.obj, xl.rng = top_left_corner, row.names = row.names, :"

 

Is the error I'm getting from the R tool.

 

Following what I read in the post https://community.alteryx.com/t5/Alteryx-Designer-Discussions/A-quick-tip-for-reading-in-password-pr... , I installed the excel.link R library successfully, but when I try to write to the excel with the following entered in the R tool: 

library("excel.link")
xl.save.file(output, filename, xl.sheet = NULL, password = "1234", write.res.password = "1234")

 

I am getting the error mentioned above. I am attaching my workflow and the excel file in question for reference. Any ideas?

0 REPLIES 0
Labels
Top Solution Authors