rexcel_readxl: Read an Excel spreadsheet like readxl

Description Usage Arguments

Description

Read an Excel spreadsheet the same way as readxl, but slower. Assumes a well behaved table of data.

Usage

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

Arguments

path

Path to the xlsx file

sheet

Sheet name or an integer

col_names

TRUE (the default) indicating we should use the first row as column names, FALSE, indicating we should generate names (X1, X2, ..., Xn) or a character vector of names to apply.

col_types

Either NULL (the default) indicating we should guess the column types or a vector of column types (values must be "blank", "numeric", "date" or "text").

na

Values indicating missing values (if different from blank). Not yet used.

skip

Number of rows to skip.


rsheets/rexcel documentation built on May 28, 2019, 3:32 a.m.