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')

1

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.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.