Description Usage Arguments Author(s) See Also
"[" method for reading all or part of a table in a MS Excel
database (referenced by 'edb'). Wrapper for
edbRead.RODBC_Excel
.
1 2 |
edb |
An object of class 'edb', such as returned by |
tableName |
Single character string. Name of the table to read in 'edb'. |
sRow |
A list of named items. List of contrains/criterion to be applied on
apply. The (vector of) value(s) of each items are the possible values that can be retrieved. Values can be character or numeric. If NULL (the default), all values are returned. |
sCol |
A vector of character strings. Names of the columns to retrieve. |
sRowOp |
A single character string. Operator to be used to combine multiple constrains in sRow. Possible values are "OR" or "AND". Default value is "AND". |
formatCol |
If not NULL, a named list of functions to be applied to certain columns after the data has been extracted from the database. The name of each list item gives the column to process, and the value of each item gives the function that must be applied. For instance formatCol = list("DATE"=as.Date) will apply the function as.Date to the column "DATE". |
distinct |
Single logical. If TRUE, unique values in the result table will be returned, using the This is equivalent to applying data.frame returned by the function, except that the action is performed inside the database (not in R). |
verbose |
Single logical. If TRUE, information on what is done are output on screen. |
... |
Additional parameters to be passed to |
Julien MOEYS <Julien.Moeys@mark.slu.se>
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.