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.