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), filename = NULL, tablename = NULL, transpose = FALSE, dec.places = NULL) excel2007Export(what = cbind(labels, WR), filename = NULL, tablename = NULL, transpose = FALSE, dec.places = NULL)
what |
a matrix, data frame or a list |
filename |
(optional) file name |
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, data frame or list with a single component,
the name of the worksheet can be specified using the optional parameter 'tablename'
.
For a list, several sheets are attached, their number and names corresponding to the items present.
Optional argument 'filename'
specifies the name of a file for exporting.
If the file already exists, but does not contain worksheets with identical names,
they are appended.
None.
These functions are not available on 64-bit systems!
The RODBC package was written by Brian Ripley.
Vojtěch Janoušek, vojtech.janousek@geology.cz
## Not run: excelExport(results) # Saves the last calculated results in XLS format excel2007Export(results) # Saves the last calculated results in XLSX (or XLS) format ## End(Not run)