excel.link: Convenient Data Exchange with Microsoft Excel
Version 0.9.8-1

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.

Package details

AuthorGregory Demin <[email protected]>. To comply CRAN policy includes source code from 'RDCOMClient' (http://www.omegahat.net/RDCOMClient) by Duncan Temple Lang <[email protected]>.
Date of publication2018-05-23 12:30:17 UTC
MaintainerGregory Demin <[email protected]>
LicenseGPL (>= 2)
Version0.9.8-1
URL https://github.com/gdemin/excel.link
Package repositoryView on CRAN
Installation Install the latest version of this package by entering the following in R:
install.packages("excel.link")

Try the excel.link package in your browser

Any scripts or data that you put into this service are public.

excel.link documentation built on May 23, 2018, 5:03 p.m.