read_excel2: Read xls and xlsx files.

Description Usage Arguments See Also

View source: R/read_excel2.R

Description

Import excel files into R similar to readxl::read_excel, but with all rows evaluated in xls_col_types and xlsx_col_types

Usage

1
2
read_excel2(path, sheet = 1, col_names = TRUE, col_types = NULL,
  na = "", skip = 0, n_max = 1050000L)

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.

n_max

Max number of rows to evalutate for internal function xls_col_types and xlsx_col_types. Defaults to all rows (1050000L)

See Also

read_excel


janzzon/readxlExtras documentation built on Dec. 22, 2020, 6:16 p.m.