Learn R Programming

⚠️There's a newer version (0.9.15) of this package.Take me there.

excel.link (version 0.9.4)

Convenient Data Exchange with Microsoft Excel

Description

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.

Copy Link

Version

Install

install.packages('excel.link')

Monthly Downloads

1,642

Version

0.9.4

License

GPL (>= 2)

Issues

Pull Requests

Stars

Forks

Maintainer

Gregory Demin

Last Published

April 16th, 2016

Functions in excel.link (0.9.4)

xl.connect.table

Live connection with data on Microsoft Excel sheet
excel.link

excel.link: convenient data exchange with Microsoft Excel
xl.write

Methods for writing data to Excel sheet
xl.workbook.add

Basic operations with Excel workbooks
xl.read.file

Functions for saving and reading data to/from Excel file.
COMStop

Functions from RDCOMClient package
xl.bind.range

Active bindings to Excel ranges
xl.index2address

Converts Excel address to indexes and vice versa.
xl.sheet.add

Basic operations with worksheets.
current.graphics

Auxiliary function for export graphics to Microsoft Excel
xl

Data exchange with running Microsoft Excel instance.
xl.get.excel

Returns reference to Excel application.
xl.current.region

Read/write from/to Excel current region.