rexcel (version 0.0.1)

rexcel_readxl: Read an Excel spreadsheet like readxl

Description

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

Usage

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.