read_excel(path, sheet = 1, col_names = TRUE, col_types = NULL, na = "", skip = 0)
TRUE
to use the first row as column names,
FALSE
to number columns sequentially from X1
to Xn
,
or a character vector giving a name for each column.NULL
to guess from the spreadsheet or a
character vector containing "blank", "numeric", "date" or "text".datasets <- system.file("extdata/datasets.xlsx", package = "readxl") read_excel(datasets) # Specific sheet either by position or by name read_excel(datasets, 2) read_excel(datasets, "mtcars")
Run the code above in your browser using DataCamp Workspace