Learn R Programming

gnumeric (version 0.7-10)

read.gnumeric.sheet.info: Read names and sizes of sheets from a gnumeric spreadsheet file

Description

Read sheet.name, width and height of sheets of a gnumeric file to a data.frame.
Also constructs cell name for the bottom.right cells, these can be passed to
read.gnumeric.sheet or read.gnumeric.range

Usage

read.gnumeric.sheet.info(file);

Value

A data.frame with colummns

Column nameTypeNote
sheet.namestring
widthintegerNumber of columns
heightintegerNumber of rows
bottom.rightstringBottom right cell name or
NA if sheet is empty

Arguments

file

Name of gnumeric file to read from.

Examples

Run this code
## Read names and sizes of sheets from 'file.gnumeric'
if (FALSE) {
df <- read.gnumeric.sheet.info( file="file.gnumeric" );
}

Run the code above in your browser using DataLab