read_6800_xlsx {gasanalyzer}

Reads 6800 xlsx files and creates a tibble with gas-exchange data.

Description

The xlsx files stored by the 6800 contain measured and calculated values that are read by this function and formatted in a large tibble for use with R. Constants and metadata (such as calibration information) are also added as columns.

Usage

read_6800_xlsx(filename, recalculate = TRUE)

Arguments

filename

an xlsx file containing 6800 gas-exchange data.

recalculate

character string indicating whether or not to recalculate data using equations from the xlsx file.

Details

Note that values for many derived gas-exchange parameters are not stored in the files, but are calculated by equations stored in the xlsx. These values are 0 after importing, unless setting recalculate = TRUE. It is also possible to calculate this parameters after importing using the recalculate() function.

Multiple files can be loaded by calling the function with lapply() or purrr::map() to merge multiple files. In this case, it is important to ensure that the column names will match. Recalculation can be disabled for speed, and instead applied to the merged data using recalculate().

Value

A tibble with gas-exchange data in columns.

See Also

recalculate()

Examples

exampledir <- system.file("extdata", package = "gasanalyzer")
# import factory calibration for example data:
import_factory_cals(exampledir)

# read data:
li6800 <- read_6800_xlsx(file.path(exampledir, "lowo2.xlsx"))
li6800_norecalc <- read_6800_xlsx(file.path(exampledir, "lowo2.xlsx"),
  recalculate = FALSE)
li6800_norecalc$gasanalyzer.Equations <-
  list(read_6800_equations(file.path(exampledir, "lowo2.xlsx")))

all.equal(li6800, recalculate(li6800_norecalc), check.attributes = FALSE)