loadeR (version 1.2.0)

carga.datos.excel: 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
)

Value

A data.frame object with the information of a file on excel.

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.

Author

Diego Jimenez <[e-mail]>

Examples

# \donttest{
  tf <- tempfile()
  writexl::write_xlsx(iris, paste0(tf, ".xlsx"), TRUE)
  carga.datos.excel(ruta = paste0(tf, ".xlsx"), row_names = FALSE, preview = TRUE)
# }