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), filename = NULL, tablename = NULL,
transpose = FALSE, dec.places = NULL)

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

Arguments

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

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, 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.

Value

None.

Warning

These functions are not available on 64-bit systems!

Author(s)

The RODBC package was written by Brian Ripley.

Vojtěch Janoušek, vojtech.janousek@geology.cz

See Also

'accessExport' 'dbfExport'

Examples

    ## 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)

[Package GCDkit version 6.3.0 Index]