Rstudio Read. Xl Working Directory Error
Hi Guys I'm Having Difficulty Loading. Xlsx into Rstudio - I'm Not Sure Why Rstudio Can't See the File. Am I Specifying the Path for Read_Excel() Wrong? Any...
Hi guys I'm having difficulty loading .xlsx into RStudio - I'm not sure why RStudio can't see the file. Am I specifying the path for read_excel() wrong? Any ideas? Pretty new at R.
Thanks!
Windows 10 (64-bit) Version 0.99.491 & Version 0.99.840 read.xl 0.1.0
getwd()
[1] "C:/Users/user/Documents/Work"
read_excel(system.file("C:/Users/user/Documents/Work/Data.xlsx"))
Error: '' does not exist in current working directory ('C:/Users/user/Documents/Work')
3 Answers
The results of the system.file command are probably returning a blank character "":
system.file("C:/Users/user/Documents/Work/Data.xlsx")
[1] ""
I'm not sure why this is the case. Instead, just try specifying the full path within the excel_sheets function, i.e.,
read_excel("C:/Users/user/Documents/Work/Data.xlsx")
I like to use paste0 function:
read_excel(paste0(getwd(), "/Data.xlsx"))
How did you save the file? Is the file saved as Data.xlsx? If so, please remove the extension .xlsx and then try to import with read_excel("Data.xlsx"). I faced the similar error and after removing the extension, it worked fine.
Alexander Ross has covered the video game industry for a decade, writing deep dives on game design, esports tournaments, VR developments, and gaming culture.
