rexcel_read: Read an xlsx file that probably contains nontabular data

Description Usage Arguments Value

Description

This function does not get the data into a usable form but at least loads it up into R so we can poke about with it. The resulting loaded data can distinguish between formulae and data, numbers and text. Merged cells are detected. Style information is included, though nothing is done with it yet. A summary of the data is printed if you print the resulting object.

Usage

1
rexcel_read(path, sheet = 1L)

Arguments

path

Path to the xlsx file to load. xls files are not supported.

sheet

Sheet number (not name at this point). Googlesheets exported sheets are likely not to do the right thing.

Value

An xlsx object that can be printed. Future methods might do something sensible. The structure is subject to complete change so is not documented here.


rsheets/rexcel documentation built on May 28, 2019, 3:32 a.m.