read.gnumeric.sheets: Read each sheet from a gnumeric spreadsheet file
In gnumeric: Read Data from Files Readable by 'gnumeric'

Description Usage Arguments Value See Also Examples

View source: R/read.gnumeric.R

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.

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

`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`

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

names(df.list); ## sheet names

## End(Not run)