contin_import_v3: Import continuous information from a template xlsx file.

In DEQrmichie/odeqcdr: ODEQ Continuous Data Review

Import continuous information from a template xlsx file.

Description

Retrieve monitoring results from Oregon DEQ's continuous data submission template xlsx file v3. This function will read the template and return a list with each list element holding a dataframe of the information for each spreadsheet. Any rows with all NAs are removed.

Usage

contin_import_v3(
  file,
  sheets = c("Organization_Details", "Projects", "Monitoring_Locations", "Deployment",
    "New_Equipment", "Results", "PrePost", "Audit_Data")
)

Arguments

file	The path and file name to template xlsx file.
sheets	Optional vector identifying sheets to import. Default is a vector of all sheets to be imported. Acceptable values include "Organization_Details", "Projects", "Monitoring_Locations", "Deployment", "New_Equipment", "Results", "PrePost", and "Audit_Data".

Details

The function returns a named list holding each worksheet from the xlsx. The name of each list element is the same as the xlsx:

• Organization_Details

• Projects

• Monitoring_Locations

• Deployment

• New_Equipment

• Results

• PrePost

• Audit_Data

Column names are made into syntactically valid names acceptable by R.

This function relies heavily upon the readxl package.

Value

list of each continuous template data

See Also

read_excel

DEQrmichie/odeqcdr documentation built on Feb. 15, 2025, 10:01 a.m.