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()'. 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.


Reference manual

It appears you don't have a PDF plugin for this browser. You can click here to download the reference manual.

install.packages("excel.link")

0.9.15 by Gregory Demin, 2 years ago


https://github.com/gdemin/excel.link


Report a bug at https://github.com/gdemin/excel.link/issues


Browse source code at https://github.com/cran/excel.link


Authors: Gregory Demin [cre] , Duncan Lang [aut] (To comply CRAN policy includes source code from 'RDCOMClient' http://www.omegahat.net/RDCOMClient/)


Documentation:   PDF Manual  


GPL (>= 2) license


Depends on methods, grDevices, utils

Suggests knitr, rmarkdown


See at CRAN