forgts

Formatted Spreadsheets to gts

https://github.com/luisdva/forgts

Science Score: 13.0%

This score indicates how likely this project is to be science-related based on various indicators:

○
CITATION.cff file
✓
codemeta.json file
Found codemeta.json file
○
.zenodo.json file
○
DOI references
○
Academic publication links
○
Academic email domains
○
Institutional organization owner
○
JOSS paper metadata
○
Scientific vocabulary similarity
Low similarity (15.0%) to scientific vocabulary

Last synced: 6 months ago · JSON representation

Repository

Formatted Spreadsheets to gts

Basic Info

Host: GitHub
Owner: luisDVA
License: other
Language: R
Default Branch: main
Homepage: https://luisdva.github.io/forgts/
Size: 2.86 MB

Statistics

Stars: 21
Watchers: 1
Forks: 1
Open Issues: 0
Releases: 1

Created over 1 year ago · Last pushed about 1 year ago

Metadata Files

Readme Changelog License

README.Rmd

---
output: github_document
---



```{r, include = FALSE}
knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)
```

# forgts 


[![r-universe status badge](https://luisdva.r-universe.dev/badges/forgts)](https://luisdva.r-universe.dev/forgts)
[![](https://www.r-pkg.org/badges/version/forgts?color=orange)](https://cran.r-project.org/package=forgts)
[![CRAN checks](https://badges.cranchecks.info/summary/forgts.svg)](https://cran.r-project.org/web/checks/check_results_forgts.html)
[![](http://cranlogs.r-pkg.org/badges/grand-total/forgts?color=blue)](https://cran.r-project.org/package=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 from CRAN:
``` r
install.packages("forgts")
```

Install from R-universe:
``` r
install.packages("forgts", repos = "https://luisdva.r-universe.dev") 
```

Install the development version of forgts from GitHub:

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

## Using forgts

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

```{r, echo=FALSE, eval=TRUE, fig.align='center', out.width="70%"}
knitr::include_graphics("man/figures/spsheetog.png", error = FALSE)
```




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

```{r example, echo=TRUE, eval=FALSE}
library(forgts)
###
example_spreadsheet <- system.file("extdata/rodentsheet.xlsx", package = "forgts")

forgts(example_spreadsheet)
```





```{r, echo=FALSE, eval=TRUE, fig.align='center', out.width="70%"}
knitr::include_graphics("man/figures/rdout.png")
```




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

Owner

Name: Luis Verde Arregoitia
Login: luisDVA
Kind: user

Website: www.liomys.mx
Repositories: 44
Profile: https://github.com/luisDVA

mammalogist

GitHub Events

Total

Create event: 2
Release event: 1
Issues event: 5
Watch event: 19
Issue comment event: 4
Push event: 39
Pull request review event: 2
Pull request event: 2
Fork event: 1

Last Year

Create event: 2
Release event: 1
Issues event: 5
Watch event: 19
Issue comment event: 4
Push event: 39
Pull request review event: 2
Pull request event: 2
Fork event: 1

Issues and Pull Requests

Last synced: 7 months ago

All Time

Total issues: 3
Total pull requests: 1
Average time to close issues: 4 days
Average time to close pull requests: 2 minutes
Total issue authors: 1
Total pull request authors: 1
Average comments per issue: 0.67
Average comments per pull request: 0.0
Merged pull requests: 1
Bot issues: 0
Bot pull requests: 0

Past Year

Issues: 3
Pull requests: 1
Average time to close issues: 4 days
Average time to close pull requests: 2 minutes
Issue authors: 1
Pull request authors: 1
Average comments per issue: 0.67
Average comments per pull request: 0.0
Merged pull requests: 1
Bot issues: 0
Bot pull requests: 0

View more stats

Top Authors

Issue Authors

luisDVA (3)

Pull Request Authors

ddiannae (1)

Top Labels

Issue Labels

ro-hackathon-2025 (1)

Pull Request Labels

Packages

Total packages: 1
Total downloads:
- cran 200 last-month

Total dependent packages: 0
Total dependent repositories: 0
Total versions: 1
Total maintainers: 1

cran.r-project.org: forgts

Convert Formatted Spreadsheets to Presentation-Ready Display Tables

Homepage: https://github.com/luisDVA/forgts
Documentation: http://cran.r-project.org/web/packages/forgts/forgts.pdf
License: MIT + file LICENSE
Latest release: 0.0.1
published about 1 year ago

Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Downloads: 200 Last month

Rankings

Dependent packages count: 27.3%

Dependent repos count: 33.6%

Average: 49.2%

Downloads: 86.7%

Maintainers (1)

luis@liomys.mx