The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

forgts

forgts reads a spreadsheet and its formatting information to produce gt tables with the same cell and text formatting as the input file.

Text and cell formats supported include:

• font face (bold, italic)
• font style (color, underline, strikethrough)
• cell fill
• cell borders (color and width)

Note that formatting in the headers is ignored intentionally in this package, and that the cell and text formatting is added iteratively on top of gt defaults.

Installation

Install the development version of forgts from GitHub:

# install.packages("remotes")
remotes::install_github("luisDVA/forgts")

Using forgts

The rodentsheet.xlsx file that comes with this package looks like this:

The function forgts will read the file and produce a gt object (shown here as an image).

library(forgts)
###
example_spreadsheet <- system.file("extdata/rodentsheet.xlsx", package = "forgts")

forgts(example_spreadsheet)

forgts() may be used in RMarkdown and Quarto documents, and the resulting gt tables may be exported with gt::gtsave().

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.