Learn R Programming

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

excel.link (version 0.9.8-1)

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()'. Additionally there are function for reading/writing 'Excel' files - 'xl.read.file'/'xl.save.file'. They are not fast but able to read/write '*.xlsb'-files and password-protected files. 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.8-1

License

GPL (>= 2)

Issues

Pull Requests

Stars

Forks

Maintainer

Gregory Demin

Last Published

May 23rd, 2018

Functions in excel.link (0.9.8-1)

xl.connect.table

Live connection with data on Microsoft Excel sheet
excel.link

excel.link: convenient data exchange with Microsoft Excel
current.graphics

Auxiliary function for export graphics to Microsoft Excel
xl.index2address

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

Excel constants and helper function for setting Excel range properties.
xl.current.region

Read/write from/to Excel current region.
xl

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

Returns reference to Excel application.
xl.sheet.add

Basic operations with worksheets.
xl.workbook.add

Basic operations with Excel workbooks
COMStop

Functions from RDCOMClient package
xl.read.file

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

Methods for writing data to Excel sheet
xl.bind.range

Active bindings to Excel ranges