excel.link
Convenient Data Exchange between R and Microsoft Excel
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
-
○Committers with academic emails
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (13.6%) to scientific vocabulary
Keywords
Keywords from Contributors
Repository
Convenient Data Exchange between R and Microsoft Excel
Statistics
- Stars: 57
- Watchers: 10
- Forks: 16
- Open Issues: 4
- Releases: 9
Topics
Metadata Files
README.md
⚠️ Looking for a new maintainer ⚠️
I live under Linuxmint since 2018 and don't use Excel for a long time. I no longer have the possibility to maintain this package and would love for someone to take it over and continue development.
excel.link
❗ Microsoft Windows and Microsoft Excel are required for this package.
Convenient Data Exchange with Microsoft Excel
Allows access to data in running instance of Microsoft Excel (e. g. xl[a1] =
xl[b2]*3 and so on). Graphics can be transferred with xl[a1] =
current.graphics(). so on). Graphics can be transferred with 'xl[a1] =
current.graphics()'. Additionally there are function for reading/writing 'Excel'
files - 'xl.read.file'/'xl.save.file'. They are not fast but able to read/write
'*.xlsb'-files and password-protected files. There is an Excel workbook with
examples of calling R from Excel in the 'doc' folder. It tries to keep things as
simple as possible - there are no needs in any additional installations besides
R, only 'VBA' code in the Excel workbook. Microsoft Excel is required for this
package.
The excel.link package mainly consists of two rather independent parts: one is for transferring data/graphics to running instance of Excel, another part - work with data table in Excel in similar way as with usual data.frame.
Transferring data
Package provided family of objects: xl, xlc, xlr and xlrc. You don't need to initialize these objects or to do any other preliminary actions. Just after execution library(excel.link) you can transfer data to Excel active sheet by simple assignment, for example: xlrc[a1] = iris. In this notation 'iris' dataset will be written with column and row names. If you doesn't need column/row names just remove 'r'/'c' letters (xlc[a1] = iris - with column names but without row names). To read Excel data just type something like this: xl[a1:b5]. You will get data.frame with values from range a1:a5 without column and row names. It is possible to use named ranges (e. g. xl[MyNamedRange]). To transfer graphics use xl[a1] = current.graphics().
Live connection
For example we put iris datasset to Excel sheet:
xlc[a1] = iris. After that we connect Excel range with R object: xl_iris = xl.connect.table("a1",row.names = FALSE, col.names = TRUE).
So we can:
- get data from this Excel range: xl_iris$Species
- add new data to this Excel range: xl_iris$new_column = 42
- sort this range: sort(xl_iris,column = "Sepal.Length")
- and more...
Aknowledgements
To comply CRAN policy includes source code from RDCOMClient package (http://www.omegahat.net/RDCOMClient) by Duncan Temple Lang (duncan at wald.ucdavis.edu).
Owner
- Name: Gregory Demin
- Login: gdemin
- Kind: user
- Website: https://ru.linkedin.com/pub/gregory-demin/16/85a/698
- Repositories: 73
- Profile: https://github.com/gdemin
GitHub Events
Total
- Issues event: 5
- Watch event: 1
Last Year
- Issues event: 5
- Watch event: 1
Committers
Last synced: 12 months ago
Top Committers
| Name | Commits | |
|---|---|---|
| Gregory Demin | g****b@g****m | 80 |
| Gregory Demin | g****n@g****m | 59 |
| kimhyungjun | s****1@g****m | 1 |
| Tomas Kalibera | t****a@g****m | 1 |
| Jim Hester | j****r@g****m | 1 |
Issues and Pull Requests
Last synced: 7 months ago
All Time
- Total issues: 32
- Total pull requests: 3
- Average time to close issues: 6 months
- Average time to close pull requests: about 20 hours
- Total issue authors: 26
- Total pull request authors: 3
- Average comments per issue: 4.03
- Average comments per pull request: 0.67
- Merged pull requests: 3
- Bot issues: 0
- Bot pull requests: 0
Past Year
- Issues: 4
- Pull requests: 0
- Average time to close issues: 4 months
- Average time to close pull requests: N/A
- Issue authors: 3
- Pull request authors: 0
- Average comments per issue: 3.5
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0
Top Authors
Issue Authors
- randomee (4)
- FelipeCarrillo (3)
- rmlopes (2)
- memotext-sherry (1)
- granterogers (1)
- DataConnection (1)
- openclosure (1)
- redarteht (1)
- Gateux (1)
- echorohit (1)
- bradSchrage (1)
- jiangxincode (1)
- mikmar16 (1)
- S-UP (1)
- larsot23 (1)
Pull Request Authors
- kalibera (2)
- jimhester (1)
- soeque1 (1)
Top Labels
Issue Labels
Pull Request Labels
Packages
- Total packages: 1
-
Total downloads:
- cran 1,198 last-month
- Total dependent packages: 0
- Total dependent repositories: 1
- Total versions: 17
- Total maintainers: 1
cran.r-project.org: excel.link
Convenient Data Exchange with Microsoft Excel
- Homepage: https://github.com/gdemin/excel.link
- Documentation: http://cran.r-project.org/web/packages/excel.link/excel.link.pdf
- License: GPL-2 | GPL-3 [expanded from: GPL (≥ 2)]
-
Latest release: 0.9.15
published about 1 year ago
Rankings
Maintainers (1)
Dependencies
- grDevices * depends
- methods * depends
- utils * depends
- knitr * suggests
- rmarkdown * suggests