Reading excel data sheet

[swhittak]

I have an excel data sheet that I need to be read as a table but the read.csv function keeps outputing that I do not have permission. I do not know how to fix it.

code:
mydata <- read.csv("my-path-to-my-sheet")

output:

Error in file(file, "rt") : cannot open the connection
In addition: Warning message:
In file(file, "rt") :
cannot open file 'my-path-to-my-sheet': Permission denied

[williaml]

Hi, does the file path refer to the right location? Is it a .csv file or a .xlsx file?

If it is an excel file, you might want to try readxl:

Read Excel Files • readxl (tidyverse.org)

[mikecrobp]

And make sure you add the file extension: .csv or .xlsx

[swhittak]

I got it, thank you!