knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "README-"
)

lifecycle

excelgesis

The goal of excelgesis is make the XML files inside .xlsx files navigable in a web browser. It's a helper package for the development and debugging of readxl. excelgesis itself is intended for strictly for personal, diagnostic, and recreational use.

You can explore some prepared example workbooks here, drawn from the readxl example and test sheets:

https://jennybc.github.io/excelgesis/

Those same workbooks are available in .xlsx form in the excelgesis package. Use xg_example() to gain access.

The definitive reference for .xlxs is Standard ECMA-376 Office Open XML File Formats:

Installation

You can install excelgesis from github with:

# install.packages("devtools")
devtools::install_github("jennybc/excelgesis")

Usage

List the included examples.

library(excelgesis)
xg_example()

Browse around the underlying XML inside those xlsx workbooks:

https://jennybc.github.io/excelgesis/

Here's how to do the same locally for the example workbook about Clippy:

unlink("clippy", recursive = TRUE)
xg_example("clippy") %>% 
  xg_inspect()
unlink("clippy", recursive = TRUE)

The convenience function xg_inspect() wraps up three operations:

Here's one last worked example using the individual functions.

unlink("datasets", recursive = TRUE)
(mg <- xg_example("datasets"))
mg %>% 
  xg_unzip() %>% 
  xg_linkify() %>% 
  xg_browse()
unlink("datasets", recursive = TRUE)


jennybc/excelgesis documentation built on April 3, 2018, 1:37 a.m.