Excel file import [R recipe]

[B2oriel]

I have an Excel file in a managed folder, I can't read my file using :

data <- dkuManagedFolderDownloadPath("dsdsJk", "file")

Even using the different options of as = : "raw", "text", "parsed" I get nothing.

[CatalinaS · Accepted solution]

You can read an Excel file from a managed folder using a code like below:

library(dataiku)
library(xlsx)

content <- dkuManagedFolderDownloadPath("hRJwLbQS","xl2.xlsx", as = "raw")
temp_f=tempfile()
writeBin(object=content, con=temp_f)
read.xlsx(temp_f, sheetName="Sheet1")

[B2oriel]

Thank you, everything is working as I expect