read.gnumeric.sheets {gnumeric} | R Documentation |
Read data from each non-empty sheet of a gnumeric file to a list of data.frames.
df.list <- read.gnumeric.sheets(file, head=FALSE, drop.empty.rows="none", drop.empty.columns="none", colnames.as.sheet=FALSE, rownames.as.sheet=colnames.as.sheet, quiet=TRUE, ... );
file |
Name of gnumeric file to read from. |
head, drop.empty.rows, drop.empty.columns |
|
colnames.as.sheet,rownames.as.sheet, quiet, ... |
These are passed to read.gnumeric.sheet
|
A list of data frames.
read.gnumeric.sheet.info
to list sheet names and
sizes.
read.gnumeric.range
to read an exact cell range of a
single sheet.
## Read all sheets from 'file.gnumeric' ## Not run: df.list <- read.gnumeric.sheets( file="file.gnumeric" ); df1 <- df.list['Sheet1']; df.list <- read.gnumeric.sheets( file="file.gnumeric", head=TRUE ); ## End(Not run)