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

AuthorGregory Demin <excel.link.feedback@gmail.com>. To comply CRAN policy includes source code from 'RDCOMClient' (http://www.omegahat.net/RDCOMClient) by Duncan Temple Lang <duncan@wald.ucdavis.edu>.
Date of publication2016-09-24 22:50:55
MaintainerGregory Demin <excel.link.feedback@gmail.com>
LicenseGPL (>= 2)
Version0.9.5
https://github.com/gdemin/excel.link

View on CRAN

Files in this package

excel.link
excel.link/inst
excel.link/inst/doc
excel.link/inst/doc/CallingRFromExcel.html
excel.link/inst/doc/CallingRFromExcel.Rmd
excel.link/inst/doc/R_connection_examples.xlsm
excel.link/src
excel.link/src/COMError.cpp
excel.link/src/converters.cpp
excel.link/src/RUtils.c
excel.link/src/RUtils.h
excel.link/src/RCOMObject.h
excel.link/src/StdAfx.h
excel.link/src/connect.cpp
excel.link/src/Makevars.win
excel.link/src/converters.h
excel.link/NAMESPACE
excel.link/NEWS
excel.link/R
excel.link/R/dimnames.excel.range.R excel.link/R/xl.R excel.link/R/utils.R excel.link/R/xl.bind.range.R excel.link/R/address2index.R excel.link/R/xl.connect.table.R excel.link/R/0zzzdebug.R excel.link/R/xl.workbooks.R excel.link/R/xl.get.excel.R excel.link/R/current.graphics.R excel.link/R/0COMError.R excel.link/R/0classes.R excel.link/R/RDCOMClient.R excel.link/R/0zzzCOMLists.R excel.link/R/0com.R excel.link/R/xl.current.region.R excel.link/R/excel.link.R excel.link/R/0zzz.R excel.link/R/xl.read.file.R excel.link/R/xl.sheet.add.R excel.link/R/xl.write.R excel.link/R/0zzzrunTime.R
excel.link/vignettes
excel.link/vignettes/CallingRFromExcel.Rmd
excel.link/MD5
excel.link/build
excel.link/build/vignette.rds
excel.link/DESCRIPTION
excel.link/man
excel.link/man/RDCOMClient.Rd excel.link/man/xl.current.region.Rd excel.link/man/xl.write.Rd excel.link/man/xl.Rd excel.link/man/xl.sheet.add.Rd excel.link/man/xl.connect.table.Rd excel.link/man/xl.bind.range.Rd excel.link/man/xl.index2address.Rd excel.link/man/xl.workbook.add.Rd excel.link/man/xl.read.file.Rd excel.link/man/excel.link.Rd excel.link/man/xl.get.excel.Rd excel.link/man/current.graphics.Rd

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

All documentation is copyright its authors; we didn't write any of that.