Get Aggregated BWB Rain Data From Excel Files

read BWB rain data from multiple XLS files with possible aggregation. Timestamps given in Local Time are converted to UTC+1 (= always winter time)

Usage

getAggregatedBwbRainDataFromExcelFiles(
  rain.xls.files,
  tableName,
  aggregation.interval = NA,
  columnNames = NULL,
  use2007Driver = FALSE,
  dbg = FALSE
)

Arguments

rain.xls.files

vector of full paths to xls files

tableName

name of sheet in Excel file(s) containing the rain data

aggregation.interval

aggregation interval in seconds. Default: NA (= no aggregation)

columnNames

optional. Vector of names of columns (after renaming with gaugeNamesShort) to return

use2007Driver

if TRUE, 2007 driver is used even if extension of xls is "xls"

dbg

if TRUE, debug messages are shown

Value

data frame with time column DateTime, indicating the begin of the 5-minutes interval to which the rain height corresponds.