xlsx
An R package to interact with Excel files using the Apache POI java library (by colearendt)
openxlsx
openxlsx - a fast way to read and write complex xslx files (by ycphs)
| xlsx | openxlsx | |
|---|---|---|
| 2 | 2 | |
| 85 | 214 | |
| - | - | |
| 0.0 | 3.5 | |
| almost 2 years ago | 6 days ago | |
| R | R | |
| - | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
xlsx
Posts with mentions or reviews of xlsx.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-06-03.
- Importing Excel Formulae into R
-
Learning R... how can I read an .xlsx file with multiple pages/worksheets into a single data frame in R?
I've used the xlsx package before and it worked great! Make sure to read the "common problems" section.
openxlsx
Posts with mentions or reviews of openxlsx.
We have used some of these posts to build our list of alternatives
and similar projects.
-
Is it bad if my function doesn't return anything
2) Like {openxlsx::write.xlsx} you could return the R object you just wrote to the file (here's the relevant source-code).
-
Issue When Writing Excel Files in R
I suppose it has. Last time I looked into it there were some very longstanding correctness bugs, as well as a very long period of inactivity. At the time this gave rise to a bunch of alternatives and most users migrated away.
What are some alternatives?
When comparing xlsx and openxlsx you can also consider the following projects:
nflfastR - A Set of Functions to Efficiently Scrape NFL Play by Play Data
future - :rocket: R package: future: Unified Parallel and Distributed Processing in R for Everyone
writexl - Portable, light-weight data frame to xlsx exporter for R
mindr - an R package which converts markdown files (.md, .Rmd) into mindmaps (brainstorms)
datapasta - On top of spaghetti, all covered in cheese....
unpivotr - Unpivot complex and irregular data layouts in R