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()'. 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.
| Version: | 0.9.13 |
| Depends: | methods, grDevices, utils |
| Suggests: | knitr, rmarkdown |
| OS_type: | windows |
| Published: | 2024-07-08 |
| DOI: | 10.32614/CRAN.package.excel.link |
| Author: | Gregory Demin. To comply CRAN policy includes source code from 'RDCOMClient' (http://www.omegahat.net/RDCOMClient/) by Duncan Temple Lang. |
| Maintainer: | Gregory Demin <excel.link.feedback at gmail.com> |
| BugReports: | https://github.com/gdemin/excel.link/issues |
| License: | GPL-2 | GPL-3 [expanded from: GPL (≥ 2)] |
| URL: | https://github.com/gdemin/excel.link |
| NeedsCompilation: | yes |
| Materials: | NEWS |
| CRAN checks: | excel.link results |
| Reference manual: | excel.link.pdf |
| Vignettes: |
Calling R from Excel |
| Package source: | excel.link_0.9.13.tar.gz |
| Windows binaries: | r-devel: excel.link_0.9.13.zip, r-release: excel.link_0.9.13.zip, r-oldrel: excel.link_0.9.13.zip |
| macOS binaries: | r-release (arm64): not available, r-oldrel (arm64): not available, r-release (x86_64): not available, r-oldrel (x86_64): not available |
| Old sources: | excel.link archive |
Please use the canonical form https://CRAN.R-project.org/package=excel.link to link to this page.