MyNixOS website logo
Description

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

R-CMD-check

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.

Metadata

Version

0.1.0

License

Unknown

Platforms (75)

    Darwin
    FreeBSD
    Genode
    GHCJS
    Linux
    MMIXware
    NetBSD
    none
    OpenBSD
    Redox
    Solaris
    WASI
    Windows
Show all
  • aarch64-darwin
  • aarch64-genode
  • aarch64-linux
  • aarch64-netbsd
  • aarch64-none
  • aarch64_be-none
  • arm-none
  • armv5tel-linux
  • armv6l-linux
  • armv6l-netbsd
  • armv6l-none
  • armv7a-darwin
  • armv7a-linux
  • armv7a-netbsd
  • armv7l-linux
  • armv7l-netbsd
  • avr-none
  • i686-cygwin
  • i686-darwin
  • i686-freebsd
  • i686-genode
  • i686-linux
  • i686-netbsd
  • i686-none
  • i686-openbsd
  • i686-windows
  • javascript-ghcjs
  • loongarch64-linux
  • m68k-linux
  • m68k-netbsd
  • m68k-none
  • microblaze-linux
  • microblaze-none
  • microblazeel-linux
  • microblazeel-none
  • mips-linux
  • mips-none
  • mips64-linux
  • mips64-none
  • mips64el-linux
  • mipsel-linux
  • mipsel-netbsd
  • mmix-mmixware
  • msp430-none
  • or1k-none
  • powerpc-netbsd
  • powerpc-none
  • powerpc64-linux
  • powerpc64le-linux
  • powerpcle-none
  • riscv32-linux
  • riscv32-netbsd
  • riscv32-none
  • riscv64-linux
  • riscv64-netbsd
  • riscv64-none
  • rx-none
  • s390-linux
  • s390-none
  • s390x-linux
  • s390x-none
  • vc4-none
  • wasm32-wasi
  • wasm64-wasi
  • x86_64-cygwin
  • x86_64-darwin
  • x86_64-freebsd
  • x86_64-genode
  • x86_64-linux
  • x86_64-netbsd
  • x86_64-none
  • x86_64-openbsd
  • x86_64-redox
  • x86_64-solaris
  • x86_64-windows