CRAN/E | excel.link

excel.link

Convenient Data Exchange with Microsoft Excel

Installation

About

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.

github.com/gdemin/excel.link
Bug report File report

Key Metrics

Version 0.9.10
Published 2021-11-02 758 days ago
Needs compilation? yes
License GPL-2
License GPL-3
CRAN checks excel.link results
OS windows

Downloads

Last 24 hours 76 -44%
Last 7 days 259 -24%
Last 30 days 1.419 -1%
Last 90 days 3.948 -2%
Last 365 days 16.510 +2%

Maintainer

Maintainer

Gregory Demin

excel.link.feedback@gmail.com

Authors

Gregory Demin. To comply CRAN policy includes source code from 'RDCOMClient'

(http://www.omegahat.net/RDCOMClient/)

by Duncan Temple Lang.

Material

NEWS
Reference manual
Package source

Vignettes

Calling R from Excel

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

r-oldrel

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

excel.link archive

Depends

methods
grDevices
utils

Suggests

knitr
rmarkdown