CODEWITHSUNDEEP
rxlsx
Theorp
Theorp

Reputation: 151

File is open and doesn't load in R

I'm trying to load an xlsx list, but a file is open and doesn't load in R.

Code:

dados_pp_master[[i]] <- data.frame(read_excel(arquivo_caracter[i], sheet = "PP Master",skip = 1, .name_repair = "minimal")

Log:

Error: Evaluation error: zip file 'V:/file/~$Schedule_3.xlsx' cannot be opened.

Is there any way to load an open xlsx file?

Upvotes: 0

Views: 149

Answers (1)

Thomas L.
Thomas L.

Reputation: 695

the ~$ at beginning of your file path implies that you are only working with a cached version of the changes? I'm pretty sure you cannot open this specific file with Excel itself, simply because it is not a "normal" excel file. The error message in that context makes a lot of sense then.

Upvotes: 1

Related Questions