Data

Tools

Indexes

Applications

Experiments

Open Source Science

openxlsx

openxlsx - a fast way to read and write complex xslx files

https://github.com/ycphs/openxlsx

Science Score: 23.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
  • ✓
    Committers with academic emails
    7 of 70 committers (10.0%) from academic institutions
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (16.8%) to scientific vocabulary

Keywords

cran r xlsx

Keywords from Contributors

tidy-data latex rmarkdown parsing fwf csv documentation-tool shiny ropensci analysis-pipeline
Last synced: 10 months ago · JSON representation

Repository

openxlsx - a fast way to read and write complex xslx files

Basic Info
Statistics
  • Stars: 234
  • Watchers: 9
  • Forks: 77
  • Open Issues: 16
  • Releases: 10
Topics
cran r xlsx
Created almost 7 years ago · Last pushed over 1 year ago
Metadata Files
Readme Changelog Contributing License Code of conduct Support

README.md

openxlsx

codecov CRAN_Status_Badge CRAN RStudio mirror downloads R-CMD-check

This R package simplifies the creation of .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java.

Note: openxlsx is no longer under active development. The package is maintained, and CRAN warnings will be fixed, but non-critical issues will not be addressed unless accompanied by a pull request. Packages that depend on openxlsx do not need to take any action, but for new developments, users are encouraged to use alternatives like readxl, writexl, or openxlsx2. The first two packages provide support for reading and writing .xlsx files. The latter package is a modern reinterpretation of openxlsx and provides similar functions to modify worksheets. However, it is not a drop-in replacement, so you may want to consult resources like the update vignette.

Installation

Stable version

Current stable version is available on CRAN via

R install.packages("openxlsx", dependencies = TRUE)

Development version

R install.packages(c("Rcpp", "remotes"), dependencies = TRUE) remotes::install_github("ycphs/openxlsx")

Example

Explore the package with a simple example:

```R library(openxlsx)

Create a new workbook and add a sheet

wb <- createWorkbook() addWorksheet(wb, "Sheet 1")

Write data to the sheet

writeData(wb, "Sheet 1", mtcars)

Save the workbook

saveWorkbook(wb, "my_mtcars.xlsx", overwrite = TRUE) ```

Bug/feature request

Please let us know which version of openxlsx you are using when posting bug reports. R packageVersion("openxlsx")

News

You can find the NEWS file here.

Owner

  • Name: Philipp Schauberger
  • Login: ycphs
  • Kind: user
  • Location: Vienna, Austria

GitHub Events

Total
  • Issues event: 42
  • Watch event: 12
  • Delete event: 2
  • Issue comment event: 80
  • Push event: 6
  • Pull request review comment event: 2
  • Pull request review event: 2
  • Pull request event: 6
  • Fork event: 4
Last Year
  • Issues event: 42
  • Watch event: 12
  • Delete event: 2
  • Issue comment event: 80
  • Push event: 6
  • Pull request review comment event: 2
  • Pull request review event: 2
  • Pull request event: 6
  • Fork event: 4

Committers

Last synced: about 1 year ago

All Time
  • Total Commits: 1,523
  • Total Committers: 70
  • Avg Commits per committer: 21.757
  • Development Distribution Score (DDS): 0.576
Past Year
  • Commits: 98
  • Committers: 14
  • Avg Commits per committer: 7.0
  • Development Distribution Score (DDS): 0.367
Top Committers
Name Email Commits
Alex Walker A****9@g****m 646
ycphs p****p@s****t 359
Jan Marvin Garbuszus j****s@r****e 161
jmbarbone j****e@g****m 66
GitHub Actions a****s@g****m 41
JoshuaSturm 2****m 40
Reinhold Kainhofer r****d@k****m 19
shrektan s****n@1****m 17
lbraglia l****a@g****m 16
Jeff Sullivan j****n@p****m 14
David Zimmermann-Kollenda d****n@h****e 11
Jean-Marie Pivette j****e@g****m 10
Blake Boswell j****l@g****m 7
Chris Stockbridge c****k@u****u 7
Vishal Katti k****l@g****m 6
Philipp Schauberger p****r@o****m 5
Noam Ross n****s@g****m 5
Henrik Seidel h****l@b****m 5
Waldir Leoncio w****o@m****o 5
Rattray D****y@g****a 5
Jonathon Istria j****a@t****u 5
iagogv a****a@g****m 4
Steven Hibble s****e@c****m 4
Benoit Thieurmel b****l@d****r 3
Jason Muhenkamp j****p@g****m 3
Luke Symes L****s@t****z 3
debarros p****s@g****m 2
t-kalinowski t****i@m****m 2
Michael Chirico m****4@g****m 2
Terrence Kunstek t****e@k****m 2
and 40 more...
Committer Domains (Top 20 + Academic)
phs.scot: 1 nist.gov: 1 redhat.com: 1 ad.mtroyal.ca: 1 arizona.edu: 1 ardata.fr: 1 openanalytics.eu: 1 uibk.ac.at: 1 nanx.me: 1 csb.gov.lv: 1 data-blitz.com: 1 pop-os.localdomain: 1 yans-mbp.hitronhub.home: 1 boehringer-ingelheim.com: 1 berkadia.com: 1 tx.technion.ac.il: 1 cs.ntua.gr: 1 factworks.com: 1 hey.com: 1 emerose.org: 1 medisin.uio.no: 1 umich.edu: 1 ruhr-uni-bochum.de: 1

Issues and Pull Requests

Last synced: 10 months ago

All Time
  • Total issues: 175
  • Total pull requests: 59
  • Average time to close issues: about 1 year
  • Average time to close pull requests: 3 months
  • Total issue authors: 137
  • Total pull request authors: 22
  • Average comments per issue: 4.63
  • Average comments per pull request: 2.14
  • Merged pull requests: 46
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 23
  • Pull requests: 8
  • Average time to close issues: 7 days
  • Average time to close pull requests: 12 days
  • Issue authors: 21
  • Pull request authors: 5
  • Average comments per issue: 1.35
  • Average comments per pull request: 2.0
  • Merged pull requests: 8
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
  • deschen1 (8)
  • JanMarvin (6)
  • klar-C (5)
  • olivier7121 (5)
  • phargarten2 (4)
  • michael-m52 (4)
  • minifiemj (3)
  • Mkranj (3)
  • tdp-datsci (2)
  • lz1nwm (2)
  • klin333 (2)
  • mingerman311 (2)
  • jmbarbone (2)
  • joshuasami (2)
  • AlvaroMCMC (2)
Pull Request Authors
  • JanMarvin (32)
  • ycphs (13)
  • michael-dewar (5)
  • jistria (4)
  • jmbarbone (3)
  • DavZim (3)
  • olivroy (2)
  • philaris (2)
  • PBfordev (2)
  • grantbrown (2)
  • nanxstats (2)
  • rpcach (1)
  • StevenHibble-Concurrence (1)
  • krystian8207 (1)
  • jmuhlenkamp (1)
Top Labels
Issue Labels
Stale (123) bug (16) fixed (13) enhancement (10) Style issue (7) low priority (6) good first issue (5) waiting for answer (4) help wanted (3) documentation (2) 3rd party issue (2) Encoding issue (1) question (1)
Pull Request Labels
Stale (6) question (1) WIP (1) bug (1)

Packages

  • Total packages: 3
  • Total downloads:
    • cran 361,420 last-month
  • Total docker downloads: 188,211
  • Total dependent packages: 194
    (may contain duplicates)
  • Total dependent repositories: 725
    (may contain duplicates)
  • Total versions: 44
  • Total maintainers: 1
cran.r-project.org: openxlsx

Read, Write and Edit xlsx Files

  • Versions: 25
  • Dependent Packages: 184
  • Dependent Repositories: 712
  • Downloads: 361,420 Last month
  • Docker Downloads: 188,211
Rankings
Dependent repos count: 0.5%
Dependent packages count: 0.6%
Downloads: 0.8%
Forks count: 1.0%
Stargazers count: 2.0%
Average: 3.7%
Docker downloads count: 17.3%
Maintainers (1)
jan.garbuszus@ruhr-uni-bochum.de
Last synced: 11 months ago
proxy.golang.org: github.com/ycphs/openxlsx
  • Versions: 7
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent packages count: 5.4%
Average: 5.6%
Dependent repos count: 5.8%
Last synced: 11 months ago
conda-forge.org: r-openxlsx
  • Versions: 12
  • Dependent Packages: 10
  • Dependent Repositories: 13
Rankings
Dependent packages count: 5.9%
Dependent repos count: 9.8%
Average: 16.4%
Forks count: 23.0%
Stargazers count: 27.1%
Last synced: 11 months ago

Dependencies

.github/workflows/R-CMD-check.yaml actions
  • actions/checkout v2 composite
  • r-lib/actions/check-r-package v2 composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/lint.yaml actions
  • actions/checkout v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/pkgdown.yaml actions
  • JamesIves/github-pages-deploy-action 4.1.4 composite
  • actions/checkout v2 composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/pr_commands.yaml actions
  • actions/checkout v2 composite
  • r-lib/actions/pr-fetch v2 composite
  • r-lib/actions/pr-push v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/revdep.yaml actions
  • actions/cache v2 composite
  • actions/checkout v2 composite
  • actions/upload-artifact v2 composite
  • r-lib/actions/setup-pandoc v1 composite
  • r-lib/actions/setup-r v1 composite
.github/workflows/stale.yaml actions
  • actions/stale v4 composite
.github/workflows/test-coverage.yaml actions
  • actions/checkout v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
DESCRIPTION cran
  • R >= 3.3.0 depends
  • Rcpp * imports
  • grDevices * imports
  • methods * imports
  • stats * imports
  • stringi * imports
  • utils * imports
  • zip * imports
  • knitr * suggests
  • rmarkdown * suggests
  • roxygen2 * suggests
  • testthat * suggests
.github/workflows/codeql.yml actions
  • actions/checkout v4 composite
  • github/codeql-action/analyze v3 composite
  • github/codeql-action/autobuild v3 composite
  • github/codeql-action/init v3 composite