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

Functions

asCOMArray Man page
.COM Man page
COMCreate Man page
COMCurrency-class Man page
COMDate-class Man page
COMDecimal-class Man page
[[,COMIDispatch,ANY-method Man page
$<-,COMIDispatch,ANY-method Man page
[[<-,COMIDispatch,character,missing-method Man page
COMIDispatch-class Man page
$,COMIDispatch-method Man page
[[<-,COMIDispatch,numeric,ANY-method Man page
[[,COMIDispatch,numeric-method Man page
.COMInit Man page
COMList Man page
COMList-class Man page
[[<-,COMList,numeric,ANY-method Man page
[[,COMList,numeric-method Man page
[,COMList,numeric,missing-method Man page
COMNames Man page
[[<-,CompiledCOMCoClass,character,ANY-method Man page
[[,CompiledCOMCoClass,character-method Man page
$<-,CompiledCOMCoClass,character-method Man page
CompiledCOMCoClass-class Man page
$,CompiledCOMCoClass-method Man page
[[<-,CompiledCOMIDispatch,character,ANY-method Man page
[[,CompiledCOMIDispatch,character-method Man page
$<-,CompiledCOMIDispatch,character-method Man page
CompiledCOMIDispatch-class Man page
$,CompiledCOMIDispatch-method Man page
[[,CompiledCOMIDispatch,numeric-method Man page
COMStop Man page
[[,COMTypedList,character-method Man page
COMTypedList-class Man page
[[,COMTypedList,numeric-method Man page
[[,COMTypedNamedList,character-method Man page
[,COMTypedNamedList,character,missing-method Man page
COMTypedNamedList-class Man page
[,COMTypedNamedList,numeric,missing-method Man page
COMTypedParameterizedNamedList-class Man page
cr Man page
[[<-.cr Man page
[[.cr Man page
\%<cr-\% Man page
\%=cr\% Man page
crc Man page
\%<crc-\% Man page
\%=crc\% Man page
createCOMReference Man page
createTypeVarName Man page
createTypeVarName,character-method Man page
createTypeVarName,COMIDispatch-method Man page
createTypeVarName,CompiledCOMCoClass-method Man page
crr Man page
\%<crr-\% Man page
\%=crr\% Man page
crrc Man page
\%<crrc-\% Man page
\%=crrc\% Man page
CurrencyVARIANT-class Man page
current.graphics Man page
DateVARIANT-class Man page
DispatchMethods Man page
EnumValue Man page
EnumValue,character,EnumValue,ANY-method Man page
EnumValue,character,missing,EnumValue-method Man page
EnumValue,character,numeric,EnumValue-method Man page
EnumValue-class Man page
EnumValue,numeric,EnumValue,ANY-method Man page
EnumValue,numeric,missing,EnumValue-method Man page
excel.link Man page
excel.link-package Man page
getCLSID Man page
getCOMElements Man page
getCOMInstance Man page
getItemClassName Man page
getItemClassName,CompiledCOMCoClass-method Man page
getItemClassName,COMTypedList-method Man page
getItemClassName,COMTypedNamedList-method Man page
HResult-class Man page
isValidCOMObject Man page
IUnknown-class Man page
lapply Man page
lapply,COMIDispatch-method Man page
lapply,COMList-method Man page
length,COMList-method Man page
names,CompiledCOMIDispatch-method Man page
names,COMTypedNamedList-method Man page
names,COMTypedParameterizedNamedList-method Man page
RDCOMClient Man page
sapply Man page
sapply,COMIDispatch-method Man page
sapply,COMList-method Man page
SCOMErrorInfo-class Man page
show,EnumValue-method Man page
sort.excel.range Man page
VARIANT-class Man page
xl Man page
[<-.xl Man page
[.xl Man page
[[<-.xl Man page
[[.xl Man page
$<-.xl Man page
$.xl Man page
\%<xl-\% Man page
\%=xl\% Man page
xl.address2index Man page
xl.bind.current.region Man page
xl.binding.address Man page
xl.bind.range Man page
xlc Man page
\%<xlc-\% Man page
\%=xlc\% Man page
xl.connect.table Man page
xl.current.region Man page
xl.get.excel Man page
xl.index2address Man page
xlr Man page
\%<xlr-\% Man page
\%=xlr\% Man page
xlrc Man page
\%<xlrc-\% Man page
\%=xlrc\% Man page
xl.read.file Man page
xl.save.file Man page
xl.selection Man page
xl.sheet.activate Man page
xl.sheet.add Man page
xl.sheet.delete Man page
xl.sheets Man page
xl.workbook.activate Man page
xl.workbook.add Man page
xl.workbook.close Man page
xl.workbook.open Man page
xl.workbooks Man page
xl.workbook.save Man page
xl.write Man page
xl.write.current.graphics Man page
xl.write.data.frame Man page
xl.write.default Man page
xl.write.list Man page
xl.write.matrix Man page

Files

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.

Please suggest features or report bugs with the GitHub issue tracker.

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