rx {easyr}

Read Excel

Description

This gets a bit complex since many errors can occur when reading in excel files. We've done our best to handle common ones. Requires packages: openxlsx, readxl, XML (these are required by easyr). It should NOT be used directly (that's why it isn't exported), but will be called by function [read.any] as necessary, with the applicable defaults set by that function.

Usage

rx(filename, sheet, first_column_name, nrows, verbose)

Arguments

filename

File path and name for the file to be read in.

sheet

The sheet to read in.

first_column_name

Pass a column name to help the function find the header row.

nrows

Number of rows to read in.

verbose

Print helpful messages via cat().

Value

Data object