flexlsx

R Package to add flextables to Excel files

https://github.com/pteridin/flexlsx

Science Score: 26.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
Found .zenodo.json file
○
DOI references
○
Academic publication links
○
Academic email domains
○
Institutional organization owner
○
JOSS paper metadata
○
Scientific vocabulary similarity
Low similarity (14.1%) to scientific vocabulary

Last synced: 9 months ago · JSON representation

Repository

R Package to add flextables to Excel files

Basic Info

Host: GitHub
Owner: pteridin
License: other
Language: R
Default Branch: main
Size: 287 KB

Statistics

Stars: 17
Watchers: 2
Forks: 4
Open Issues: 0
Releases: 4

Created almost 3 years 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%"
)
```

# flexlsx 



[![Lifecycle: experimental](https://img.shields.io/badge/lifecycle-experimental-orange.svg)](https://lifecycle.r-lib.org/articles/stages.html#experimental) [![Codecov test coverage](https://codecov.io/gh/pteridin/flexlsx/branch/main/graph/badge.svg)](https://app.codecov.io/gh/pteridin/flexlsx?branch=main)
[![R-CMD-check](https://github.com/pteridin/flexlsx/actions/workflows/R-CMD-check.yaml/badge.svg)](https://github.com/pteridin/flexlsx/actions/workflows/R-CMD-check.yaml)


The primary objective of `flexlsx` is to offer an effortless interface for exporting `flextable` objects directly to Microsoft Excel. Building upon the robust foundation provided by `openxlsx2` and `flextable`, `flexlsx` ensures compatibility, precision, and efficiency when working with both trivial and complex tables.

## Installation

You can install the development version of `flexlsx` like so:

``` r
# install.packages("remotes")
remotes::install_github("pteridin/flexlsx")
```

Or install the CRAN release like so:

``` r
install.packages("flexlsx")
```

## Example

This is a basic example which shows you how to solve a common problem:

``` r
library(flexlsx)

# Create a flextable and an openxlsx2 workbook
ft <- flextable::as_flextable(table(mtcars[,1:2]))
wb <- openxlsx2::wb_workbook()$add_worksheet("mtcars")

# add the flextable ft to the workbook, sheet "mtcars"
# offset the table to cell 'C2'
wb <- wb_add_flextable(wb, "mtcars", ft, dims = "C2")

# save the workbook to a temporary xlsx file
tmpfile <- tempfile(fileext = ".xlsx")
wb$save(tmpfile)

```

Owner

Name: Tobias Heidler
Login: pteridin
Kind: user
Location: Germany

Repositories: 2
Profile: https://github.com/pteridin

Pharmacist & Data Analyst/Scientist from Germany

GitHub Events

Total

Create event: 9
Commit comment event: 4
Release event: 3
Issues event: 14
Watch event: 4
Delete event: 9
Issue comment event: 35
Push event: 37
Pull request review event: 3
Pull request review comment event: 3
Pull request event: 20
Fork event: 2

Last Year

Create event: 9
Commit comment event: 4
Release event: 3
Issues event: 14
Watch event: 4
Delete event: 9
Issue comment event: 35
Push event: 37
Pull request review event: 3
Pull request review comment event: 3
Pull request event: 20
Fork event: 2

Issues and Pull Requests

Last synced: 10 months ago

All Time

Total issues: 4
Total pull requests: 9
Average time to close issues: 1 day
Average time to close pull requests: 3 days
Total issue authors: 4
Total pull request authors: 2
Average comments per issue: 4.0
Average comments per pull request: 0.44
Merged pull requests: 6
Bot issues: 0
Bot pull requests: 0

Past Year

Issues: 4
Pull requests: 9
Average time to close issues: 1 day
Average time to close pull requests: 3 days
Issue authors: 4
Pull request authors: 2
Average comments per issue: 4.0
Average comments per pull request: 0.44
Merged pull requests: 6
Bot issues: 0
Bot pull requests: 0

View more stats

Top Authors

Issue Authors

pteridin (5)
quarkoniumm (1)
fh-erica-yim (1)
MeganMcAuliffe (1)
jolahy (1)
ZhaonanFang (1)

Pull Request Authors

pteridin (9)
JanMarvin (5)

Top Labels

Issue Labels

bug (3) enhancement (3) wontfix (1) help wanted (1)

Pull Request Labels

bug (1) enhancement (1)

Packages

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

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

cran.r-project.org: flexlsx

Exporting 'flextable' to 'xlsx' Files

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

Versions: 6
Dependent Packages: 0
Dependent Repositories: 0
Downloads: 367 Last month

Rankings

Dependent packages count: 27.8%

Dependent repos count: 35.6%

Average: 49.5%

Downloads: 85.1%

Maintainers (1)

flexlsx@heidler.ovh