read.gnumeric.sheets {gnumeric}R Documentation

Read each sheet from a gnumeric spreadsheet file

Description

Read data from each non-empty sheet of a gnumeric file to a list of data.frames.

Usage


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,
                                ...  
                                );

Arguments

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

Value

A list of data frames.

See Also

read.gnumeric.sheet.info to list sheet names and sizes.

read.gnumeric.range to read an exact cell range of a single sheet.

Examples

## 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)


[Package gnumeric version 0.5-3 Index]