Export to Excel {GCDkit} | R Documentation |
This function serves for exporting the specified data into XLS or XLSX (MS Excel) formats (via the ODBC interface).
excelExport(what=cbind(labels, WR), tablename =NULL, transpose=FALSE, dec.places=NULL) excel2007Export(what=cbind(labels, WR), tablename =NULL, transpose=FALSE, dec.places=NULL)
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 |
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.
None.
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.
The RODBC package was written by Brian Ripley.
Vojtech Janousek, vojtech.janousek@geology.cz
excelExport(results) # Saves the last calculated results in XLS format excel2007Export(results) # Saves the last calculated results in XLSX (or XLS) format