Imports multiple analytics sheets from an EXCEL spreadsheet

import_sheets(
  xlsPath,
  sheets_analytics,
  sheet_parameters = "Parameters",
  sheet_sites = "Sites",
  sheet_location = "Location",
  col_rawData_pattern = "raw",
  col_ignore_pattern = "mean|empty|X_|RX|not_used",
  skip = 69,
  tz_org = NULL,
  tz_export = "UTC",
  dbg = TRUE
)

Arguments

xlsPath	path to xls file with analytics data
sheets_analytics	a character vector with the names of the sheets with analytics data (check with: readxl::excel_sheets(xlsPath))
sheet_parameters	sheet name containing parameter metadata (default: "Parameters")
sheet_sites	sheet name containing sites metadata (default: "Sites")
sheet_location	sheet name containing location metadata (default: "Location")
col_rawData_pattern	specify pattenr of columns containing raw data (default: "raw")
col_ignore_pattern	specify pattern of columns that should be ignored of importing (default: "mean\|empty\|X_\|RX\|not_used")
skip	number of rows in sheet to skip (default: 69),
tz_org	specify timezone of samples (default: "UTC")
tz_export	specify timezone for data export (default: "UTC")
dbg	print debug messages (default: TRUE)

Value

returns data frame with normalised analytics data in list form