Description Usage Arguments Details Value Author(s) See Also Examples
In Excel, save data to a csv file. Uuse this function to read that data into an R variable.
1 2 3 4 5 |
file |
file to read from;
if not specified ( |
stringsAsFactors |
keep default |
simplify |
should matrices with length 1 in one of the dimensions be converted to vectors (TRUE)? |
drop |
keep default |
na.strings |
strings that you want considered to be NA |
zero.strings |
strings that you want considered to be zero |
convertFormattedNumbers |
do you want to eliminate dollar signs, commas, etc. in formatted numbers (TRUE) or read those cells as character values (FALSE)? |
... |
other stuff |
header |
did you copy the column header(s) too? |
rowheader |
did you copy the row header(s)/name(s) too? |
Essentially a wrapper for R's read.csv function that standardizes the argument list throughout the excelRio package.
An R object, either a data.frame, a matrix or a vector.
dmm
writeToCsv, readFromExcel, pasteFromExcel, copyToExcel
1 2 3 4 5 6 | # In Excel, save a sheet of data to a csv file, e.g., Book1.csv.
# Suppose the data was a table of data by accident year,
# with the accident years being in column A, thereby "naming" the rows of data.
# Back in R ...
### NOT RUN
# x <- readFromCsv("Book1.csv", rowheader = TRUE)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.