Read each sheet from a gnumeric spreadsheet file

Share:

Description

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

All arguments are passed to read.gnumeric.sheet.

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
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,
                     LANG='C',                  
                     locale='C',                
                     import.encoding=NA,        
                     field.format='automatic',  
                     ...  
                     );

Arguments

file

Name of gnumeric file to read from.

head, drop.empty.rows, drop.empty.columns

See read.gnumeric.sheet

colnames.as.sheet,rownames.as.sheet, quiet

See read.gnumeric.sheet

LANG, locale, import.encoding, field.format, ...

See 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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
## 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 );

names(df.list); ## sheet names

## End(Not run)