read_BWB_LaboratoryReportFromXls

NOTE: only rows are used in which parameter, LabMethodName and LabUnits are given

read_BWB_LaboratoryReportFromXls(
  labResult.xls,
  sheetName = "Tabelle1",
  date.format = kwb.utils::underscoreToPercent("_d._m._Y"),
  methodRequired = FALSE,
  dbg = FALSE,
  open.on.error = TRUE
)

Arguments

labResult.xls

full path to Excel file

sheetName

name of sheet in Excel file. Default: "Tabelle1"

date.format

date format used in Excel file. Default: "%d.%m.%Y"

methodRequired

if TRUE, only those rows of the Excel file are considered in which a method is given in column "Methode". Default: FALSE

dbg

print debug messages (default: FALSE)

open.on.error

open on error (default: TRUE)

Value

data frame with columns VariableCode, LabSampleCode, SamplingDate, SiteCode, DataValueText, LabMethodName, LabUnits