Generates a Spreadsheet Report from an 'rmarkdown' File

Convert an R Markdown documents into an '.xlsx' spreadsheet reports with the knitxl() function, which works similarly to knit() from the 'knitr' package. The generated report can be opened in 'Excel' or similar software for further analysis and presentation.

knitxl

knitxl converts an Rmarkdown file into an .xlsx file. It uses knitr to parse the Rmd files and evaluate code chunks. knitx comes with features to customize the output .xlsx file.

Example

This will convert an .Rmd file into an .xlsx file:

library(knitxl)
path_to_rmd_file <- system.file("examples/minimal-example.Rmd", package = "knitxl")
knitxl(path_to_rmd_file)

Installation

From CRAN

Most users should install the latest release version of knitxl from CRAN with:

install.packages("knitxl")

From GitHub

You can install the development version of knitxl from GitHub with:

# install.packages("devtools")
devtools::install_github("dreanod/knitxl")

How knitxl works

knitxl relies on knitr to parse an .Rmd file and evaluate the code chunks. knitxl attaches special hooks to knitr, which will save the text, source code, and results of knitr evaluation to an R6 object that represents the content of an .xlsx file. openxlsx is used for creating, writing, styling and saving this object to the .xlsx output.