rx: Read Excel

In easyr: Helpful Functions from Oliver Wyman Actuarial Consulting

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

easyr documentation built on March 31, 2023, 6:22 p.m.