Generates a Spreadsheet Report from an 'rmarkdown' File.
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.