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.

Author
Gregory 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 publication
2016-09-24 22:50:55
Maintainer
Gregory Demin <excel.link.feedback@gmail.com>
License
GPL (>= 2)
Version
0.9.5
URLs

View on CRAN

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.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

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