excel.link: Convenient Data Exchange with Microsoft Excel
Version 0.9.7

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 publication2017-05-01 10:20:11 UTC
MaintainerGregory Demin <excel.link.feedback@gmail.com>
LicenseGPL (>= 2)
Version0.9.7
URL https://github.com/gdemin/excel.link
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("excel.link")

Getting started

Calling R from Excel"

Popular man pages

excel.link: excel.link: convenient data exchange with Microsoft Excel
RDCOMClient: Functions from RDCOMClient package
xl: Data exchange with running Microsoft Excel instance.
xl.connect.table: Live connection with data on Microsoft Excel sheet
xl.current.region: Read/write from/to Excel current region.
xl.read.file: Functions for saving and reading data to/from Excel file.
xl.workbook.add: Basic operations with Excel workbooks
See all...

All man pages Function index File listing

Man pages

current.graphics: Auxiliary function for export graphics to Microsoft Excel
excel.link: excel.link: convenient data exchange with Microsoft Excel
RDCOMClient: Functions from RDCOMClient package
xl: Data exchange with running Microsoft Excel instance.
xl.bind.range: Active bindings to Excel ranges
xl.connect.table: Live connection with data on Microsoft Excel sheet
xl.current.region: Read/write from/to Excel current region.
xl.get.excel: Returns reference to Excel application.
xl.index2address: Converts Excel address to indexes and vice versa.
xl.property: Excel constants and helper function for setting Excel range...
xl.read.file: Functions for saving and reading data to/from Excel file.
xl.sheet.add: Basic operations with worksheets.
xl.workbook.add: Basic operations with Excel workbooks
xl.write: Methods for writing data to Excel sheet

Functions

Files

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

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

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

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