getExcelSheet: Retrieve an MS Excel (R) sheet from an 'xls' or 'xlsx' file.

In lbraglia/yapomif: Yet another package of misc functions

Description

This function is a wrapper around RODBC function to get a sheet from an xls or xlsx file.

Usage

getExcelSheet(file = NULL, sheet = NULL, ...)

Arguments

file	path to the xls xlsx file
sheet	sheet name
...	other arguments passed to sqlFetch

Value

The function return a data.frame with data from the specified sheet.

Examples

   ## Not run: 
getExcelSheet(file="C:/foo.xls", sheet="es_ps")

## End(Not run)

lbraglia/yapomif documentation built on May 20, 2019, 11:26 p.m.