Learn R Programming

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

excel.link (version 0.9.7)

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

License

GPL (>= 2)

Issues

Pull Requests

Stars

Forks

Maintainer

Gregory Demin

Last Published

May 1st, 2017

Functions in excel.link (0.9.7)

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

Functions from RDCOMClient package
current.graphics

Auxiliary function for export graphics to Microsoft Excel
xl.read.file

Functions for saving and reading data to/from Excel file.
xl.sheet.add

Basic operations with worksheets.
xl.index2address

Converts Excel address to indexes and vice versa.
xl.property

Excel constants and helper function for setting Excel range properties.
excel.link

excel.link: convenient data exchange with Microsoft Excel
xl

Data exchange with running Microsoft Excel instance.
xl.workbook.add

Basic operations with Excel workbooks
xl.write

Methods for writing data to Excel sheet