xls_import: Import, clean and tidy data from a Excel file

In lhmet/rinmetxls: Read Meteorological Data From Excel Files Distribuited By INMET

Description

Import, clean and tidy data from a Excel file

Usage

xls_import(file.xls, verbose = TRUE, na.strings = "NULL",
  kjm2.wm2 = (1000/10^6)/0.0864 * 24)

Arguments

file.xls	Import data from a Excel file
verbose	a logical indicating if some “progress report” should be given.
na.strings	Character vector of strings to interpret as missing values. By default, readxl treats blank cells as missing data. Default: 'NULL'.
kjm2.wm2	unit conversion for solar incoming radiation, Default: (1000/10^6)/0.0864 * 24. Set equal to NULL to not apply unit conversion to W m^-2^.

Details

This function import and tidy data from a Excel data file.

Value

data frame with tidy data

See Also

xls_read, data_clean, data_tidy

Examples

## Not run: 
if(interactive()){
xfiles_l <- list.files(
  "vignettes/dvd_xls_files",
  recursive = TRUE,
  full.names = TRUE
)
xls_file <- sample(xfiles_l, 1)
aws_data <- xls_import(file.xls = xls_file)
str(aws_data)
attr(aws_data, "meta")
 }

## End(Not run)

lhmet/rinmetxls documentation built on May 28, 2019, 11:33 a.m.