I'm using RStudio, and trying to call my data into R. I installed the package "readxl" to read in my excel data, the installation worked fine. But when I go to when I called library(readxl), I kept getting the error:
Error in read_excel("Main1.xlsx", sep = "\t", header = TRUE) : unused arguments (sep = "\t", header = TRUE)
Read the error messaqge carefully. What does it say?
Read the documentation about the function (?read_excel). What arguments can be used?
I don't think you need to specify the arguments sep and header with the read_excel() function. Try just :
read_excel("Main1.xlsx")
I suggest using the GUI method in Rstudio (import data set > From Excel)
Then at the bottom right, it types out the function for you, learn from it and how it writes the arguments, then copy it to your code, and modify it to your needs (change the range, or data types, etc).
- Badges
- Science topic