Data

Tools

Indexes

Applications

Experiments

Open Source Science

tablexlsx

R package to export data frames from R to xlsx workbook

https://github.com/ddotta/tablexlsx

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 (17.8%) to scientific vocabulary

Keywords

conversion dataframe export package xlsx
Last synced: 6 months ago · JSON representation

Repository

R package to export data frames from R to xlsx workbook

Basic Info
Statistics
  • Stars: 16
  • Watchers: 2
  • Forks: 1
  • Open Issues: 12
  • Releases: 3
Topics
conversion dataframe export package xlsx
Created about 3 years ago · Last pushed over 1 year ago
Metadata Files
Readme Contributing License

README.md

version cranlogs Downloads R check status codecov CodeFactor <!-- badges: end -->

:package: Package tablexlsx

R package that allows to export data frames from R to xslx workbooks.

Installation

To install tablexlsx from CRAN :

r install.packages("tablexlsx")

Or alternatively to install the development version from GitHub :

r remotes::install_github("ddotta/tablexlsx")

Then to load it :

r library(tablexlsx)

Why this package ?

This package is a wrapper of some functions from the great openxlsx package

The purpose of this package is to meet the needs of R users who want to export data frames in xlsx files to share their data and results with other users not necessarily R users.

The goal is to get an API that is as simple as possible to use. It's intended to meet the needs of users who want to create clean, well-documented xlsx files (with a title and footnotes).

The package will be improved over time and will include new features based on the needs expressed by users. To do so, feel free to open an issue here.

Advantages

Some advantages of using this package :

  • A simpler syntax for common export operations of excel files;
  • It can write several data frames in the same sheet one below the other;
  • It can merge modalities for one or several columns;
  • It can automatically open files as soon as they are created so you can inspect your workbook;
  • Data frames to be exported in xlsx files can be passed as an argument in functions as simple tables or list of tables;
  • The main function of the package toxlsx() works interchangeably with %>% and |> operators and these 3 syntaxes below are equivalent :

toxlsx(object = iris, path = mypath) iris |> toxlsx(path = mypath) iris %>% toxlsx(path = mypath)

:pointright: For more, see examples gallery in this vignette :magright:

Owner

  • Name: Damien Dotta
  • Login: ddotta
  • Kind: user
  • Location: Toulouse, France
  • Company: @InseeFr @InseeFrLab

GitHub Events

Total
  • Create event: 2
  • Release event: 2
  • Issues event: 2
  • Issue comment event: 4
  • Push event: 8
  • Pull request event: 1
  • Pull request review event: 1
Last Year
  • Create event: 2
  • Release event: 2
  • Issues event: 2
  • Issue comment event: 4
  • Push event: 8
  • Pull request event: 1
  • Pull request review event: 1

Issues and Pull Requests

Last synced: 6 months ago

All Time
  • Total issues: 33
  • Total pull requests: 11
  • Average time to close issues: about 1 month
  • Average time to close pull requests: 13 days
  • Total issue authors: 3
  • Total pull request authors: 2
  • Average comments per issue: 0.7
  • Average comments per pull request: 2.0
  • Merged pull requests: 11
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 3
  • Pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 1
  • Pull request authors: 0
  • Average comments per issue: 0.33
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
  • JulienBlasco (17)
  • ddotta (14)
  • teorems (1)
Pull Request Authors
  • JulienBlasco (12)
  • ddotta (3)
Top Labels
Issue Labels
Pull Request Labels

Packages

  • Total packages: 1
  • Total downloads:
    • cran 234 last-month
  • Total dependent packages: 0
  • Total dependent repositories: 0
  • Total versions: 3
  • Total maintainers: 1
cran.r-project.org: tablexlsx

Export Data Frames to Excel Workbook

  • Versions: 3
  • Dependent Packages: 0
  • Dependent Repositories: 0
  • Downloads: 234 Last month
Rankings
Stargazers count: 21.1%
Forks count: 28.8%
Dependent packages count: 29.8%
Average: 35.3%
Dependent repos count: 35.5%
Downloads: 61.3%
Maintainers (1)
damien.dotta@live.fr
Last synced: 6 months ago