xlsx
An R package to interact with Excel files using the Apache POI java library (by colearendt)
unpivotr
Unpivot complex and irregular data layouts in R (by nacnudus)
xlsx | unpivotr | |
---|---|---|
2 | 2 | |
85 | 182 | |
- | - | |
0.0 | 0.0 | |
almost 2 years ago | 9 months 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.
unpivotr
Posts with mentions or reviews of unpivotr.
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
maybe try {unpivotr} (https://nacnudus.github.io/unpivotr/) or {tidyxl} packages?
-
[Question] Currently painstakingly copying and pasting data from messy, unformatted Excel spreadsheet into a new spreadsheet in order to analyze it. Is there an easier way?
If you’re okay programmer in R, try the unpivotr package https://github.com/nacnudus/unpivotr
What are some alternatives?
When comparing xlsx and unpivotr you can also consider the following projects:
openxlsx - openxlsx - a fast way to read and write complex xslx files
datapasta - On top of spaghetti, all covered in cheese....
nflfastR - A Set of Functions to Efficiently Scrape NFL Play by Play Data
googlesheets4 - Google Spreadsheets R API (reboot of the googlesheets package)
writexl - Portable, light-weight data frame to xlsx exporter for R
excel.link - Convenient Data Exchange between R and Microsoft Excel