rx: Read Excel

In oliver-wyman-actuarial/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

oliver-wyman-actuarial/easyr documentation built on Jan. 27, 2024, 4:37 a.m.