Export to Excel {GCDkit}R Documentation

Export to Excel

Description

This function serves for exporting the specified data into XLS or XLSX (MS Excel) formats (via the ODBC interface).

Usage

excelExport(what=cbind(labels, WR), tablename =NULL,
transpose=FALSE, dec.places=NULL)

excel2007Export(what=cbind(labels, WR), tablename =NULL,
transpose=FALSE, dec.places=NULL)

Arguments

what

a matrix, data frame or a list

tablename

name of the data sheet

transpose

logical; transpose the data?

dec.places

numeric; number of decimal places

Details

The functions excelExport and excel2007Export output the specified data via Microsoft's ODBC interface, taking an advantage of the library 'RODBC'.

If the argument 'what' is a matrix or data frame, the name of the sheet can be specified using the optional parameter 'tablename'.

For a list, several sheets are attached, their number and names corresponding to the items present.

Value

None.

Warning

These functions are not available on 64-bit systems!

Unfortunately the way the ODBC is programmed by Microsoft does not make opening a new Excel file possible. Thus only adding new sheet(s) to a pre-existing spreadsheet file is feasible.

Author(s)

The RODBC package was written by Brian Ripley.

Vojtech Janousek, vojtech.janousek@geology.cz

See Also

'accessExport' 'dbfExport'

Examples

excelExport(results) # Saves the last calculated results in XLS format

excel2007Export(results) # Saves the last calculated results in XLSX (or XLS) format

[Package GCDkit version 4.0 Index]