read_field_xlsx: Read Field Data in an Excel Workbook

View source: R/read_field_xlsx.R

read_field_xlsxR Documentation

Read Field Data in an Excel Workbook

Description

Read worksheet(s) of Multilevel Monitoring System (MLMS) field data in an Excel workbook.

Usage

read_field_xlsx(
  path,
  sheet = NULL,
  pattern = "^[0-9]{1,2}-[0-9]{1,2}-[0-9]{2,4}$"
)

Arguments

path

'character' string. Path to the Excel workbook (xlsx) to read.

sheet

'character' vector. Name of the Excel worksheet(s) to read. Sheet names may also be specified via the pattern argument. If neither argument specifies the sheet, defaults to the first sheet in the workbook.

pattern

'character' string. A pattern (regular expression) used to identify worksheet names in the workbook.

Value

A list with data frame components.

Author(s)

J.C. Fisher, U.S. Geological Survey, Idaho Water Science Center

Examples

path <- system.file("extdata/ex-field.xlsx", package = "mlms")
l <- read_field_xlsx(path, sheet = "06-30-2022")
str(l, max.level = 1)

mlms documentation built on April 4, 2025, 4:43 a.m.