cas.read.xlsx | R Documentation |
This function is a convenience wrapper for
the R read.xlsx
and as.casTable
functions.
After reading the file that is accessible to the R
client, it is uploaded to an in-memory table in
CAS (the server).
cas.read.xlsx(
conn,
file,
sheetIndex = 1,
sheetName = NULL,
rowIndex = NULL,
startRow = NULL,
endRow = NULL,
colIndex = NULL,
as.data.frame = TRUE,
header = TRUE,
colClasses = NA,
keepFormulas = FALSE,
encoding = "unknown",
casOut = list(name = "", replace = FALSE)
)
conn |
An instance of a CAS object that represents a connection and CAS session. |
file |
An |
sheetIndex |
An optional |
sheetName |
An optional |
rowIndex |
An optional |
startRow |
An optional |
endRow |
An optional |
colIndex |
An optional |
as.data.frame |
An optional |
header |
An optional |
colClasses |
An optional |
keepFormulas |
An optional |
encoding |
An optional |
casOut |
An optional
|
CASTable
Other functions for loading in-memory data:
cas.read.csv()
,
cas.read.jmp()
,
cas.read.sas7bdat()
,
cas.read.table()
,
cas.readRDS()
## Not run:
myCasTable <- cas.read.xlsx(s, file="/path/to/data_out.xlsx",
sheetIndex = 1,
casOut=list(name="mycastable", replace=TRUE))
## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.