0th

Percentile

##### Usage
read_excel(path, sheet = 1, col_names = TRUE, col_types = NULL, na = "", skip = 0)
##### Arguments
path
Path to the xls/xlsx file
sheet
Sheet to read. Either a string (the name of a sheet), or an integer (the position of the sheet). Defaults to the first sheet.
col_names
Either 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.
col_types
Either NULL to guess from the spreadsheet or a character vector containing "blank", "numeric", "date" or "text".
na
Missing value. By default readxl converts blank cells to missing data. Set this value if you have used a sentinel value for missing values.
skip
Number of rows to skip before reading any data.
##### Examples
datasets <- system.file("extdata/datasets.xlsx", package = "readxl")

Note that the Excel spreadsheet must be local (a URL does not work). Example of creating, writing and reading a spreadsheet: {r} d=tribble( ~x, ~y, 1, 10, 2, 12, 3, 13, 4, 12 ) d l=list(d) openxlsx::write.xlsx(l, file = "thing.xlsx") d2=read_excel("thing.xlsx") d2