knitr::opts_chunk$set( collapse = TRUE, comment = "#>", fig.path = "README-" )
The goal of excelgesis is to make the XML files inside Excel's
.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.
Despite zero planning on my part, it works equally well for other Office Open XML File Formats, like Word and PowerPoint. A happy fact pointed out to me on Twitter.
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:
You can install excelgesis from github with:
# install.packages("devtools") devtools::install_github("jennybc/excelgesis")
List the included examples.
Browse around the underlying XML inside those xlsx workbooks:
Here's how to do the same locally for the example workbook about Clippy:
xg_example("clippy") %>% fs::file_copy(new_path = ".") %>% xg_inspect()
In an interactive session, clippy's landing page will open in your browser for XML browsing fun times.
The convenience function
xg_inspect() wraps up three operations:
Here's one last worked example using the individual functions.
(mg <- xg_example("datasets")) mg %>% fs::file_copy(new_path = ".") %>% xg_unzip() %>% xg_linkify() %>% xg_browse()
You haven't really seen iris or mtcars until you've seen them as XML.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.