import_sheet: Imports an analytics sheet from an EXCEL spreadsheet

In KWB-R/kwb.pilot: Importing, Aggregating and Visualising Data From KWB Pilot Plants

Imports an analytics sheet from an EXCEL spreadsheet

Description

Imports an analytics sheet from an EXCEL spreadsheet

Usage

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

KWB-R/kwb.pilot documentation built on Nov. 1, 2022, 2:49 p.m.