Imports an analytics sheet from an EXCEL spreadsheet

import_sheet(xlsPath, sheet, col_names = TRUE, col_rawData_pattern = "raw",
  col_ignore_pattern = "mean|empty|X_|RX|not_used", skip = 69,
  tz_org = "UTC", tz_export = "UTC")

Arguments

xlsPath

path to xls file with analytics data

sheet

a sheet in spreadsheet defined with "xlsPath" containing analytics data (check with: readxl::excel_sheets(xlsPath))

col_names

do the (default: TRUE) (default: "DateTime"),

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")

Value

returns data frame with normalised analytics data in list form