read_excel: Read xls and xlsx files.
Read xls and xlsx files.
read_excel(path, sheet = 1, col_names = TRUE, col_types = NULL, na = "", skip = 0)
Path to the xls/xlsx file
Sheet to read. Either a string (the name of a sheet), or
an integer (the position of the sheet). Defaults to the first sheet.
TRUE to use the first row as column names,
FALSE to number columns sequentially from
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".
Missing value. By default readxl converts blank cells to missing
data. Set this value if you have used a sentinel value for missing values.
Number of rows to skip before reading any data.
datasets <- system.file("extdata/datasets.xlsx", package = "readxl")
# Specific sheet either by position or by name