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.
rx(filename, sheet, first_column_name, nrows, verbose)Data object
File path and name for the file to be read in.
The sheet to read in.
Pass a column name to help the function find the header row.
Number of rows to read in.
Print helpful messages via cat().