In ebenp/xlsxtracter: Extract row, column tabular data in a programmatic fashion

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)

xlsxtracter

The goal of xlsxtracter is to provide a programmatic way to extract tabular data from Excel using lettered cell references (i.e. A4)

Installation

You can install the development version from GitHub with:

# install.packages("devtools")
devtools::install_github("ebenp/xlsxtracter")

Examples

library(xlsxtracter)
# This includes a user supplied header
# Example with test1.xlsx in the tests folder
infile <- "tests/testthat/test1.xlsx"
sheet <- "Sheet1"
header <- c("col1", "col2","col3")
rows <- seq(4, 15)
# this is a list of header names, Excel lettered cells, rows
colrow = list(c("A", "B","C"), rows)

# returns a dataframe
d <- xlsxtractor(infile, colrow, header = header)

library(xlsxtracter)
# This reads the header in
# Example with test1.xlsx in the tests folder
infile <- "tests/testthat/test1.xlsx"
sheet <- "Sheet1"
header <- NULL
rows <- seq(3, 15)
# this is a list of header names, Excel lettered cells, rows
colrow = list(c("A", "B","C"), rows)

# returns a dataframe
d <- xlsxtractor(infile, colrow, header = header)

ebenp/xlsxtracter documentation built on Dec. 20, 2021, 3:12 a.m.