| carga.datos.excel {loadeR} | R Documentation |
Load data from excel.
Description
Load data from excel.
Usage
carga.datos.excel(
ruta,
sheet = 1,
header = TRUE,
startRow = 0,
startCol = 0,
endRow = 0,
endCol = 0,
row_names = TRUE,
deleteNA = TRUE,
preview = FALSE
)
Arguments
ruta |
the name of the file which the data are to be read from. |
sheet |
The name or index of the worksheet to read from. |
header |
a logical value indicating whether the file contains the names of the variables as its first line. |
startRow |
The index of the first row to read from. Defaults to 0 meaning that the start row is determined automatically. |
startCol |
The index of the first column to read from. Defaults to 0 meaning that the start column is determined automatically. |
endRow |
The index of the last row to read from. Defaults to 0 meaning that the end row is determined automatically. |
endCol |
The index of the last column to read from. Defaults to 0 meaning that the end column is determined automatically. |
row_names |
a logical value indicating whether the file contains the names of the rows as its first column. |
deleteNA |
a logical value indicating if rows with NA should be removed. |
preview |
a logical value indicating if only load the first 10 rows. |
Value
A data.frame object with the information of a file on excel.
Author(s)
Diego Jimenez <diego.jimenez@promidat.com>
Examples
tf <- tempfile()
writexl::write_xlsx(iris, paste0(tf, ".xlsx"), TRUE)
carga.datos.excel(ruta = paste0(tf, ".xlsx"), row_names = FALSE, preview = TRUE)