Learn R Programming

excel.link (version 0.9.13)

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,148

Version

0.9.13

License

GPL (>= 2)

Issues

Pull Requests

Stars

Forks

Maintainer

Last Published

July 8th, 2024

Functions in excel.link (0.9.13)

xl.get.excel

Returns reference to Excel application.
xl.bind.range

Active bindings to Excel ranges
xl.index2address

Converts Excel address to indexes and vice versa.
xl.connect.table

Live connection with data on Microsoft Excel sheet
xl.property

Excel constants and helper function for setting Excel range properties.
current.graphics

Auxiliary function for export graphics to Microsoft Excel
xl

Data exchange with running Microsoft Excel instance.
excel.link-package

excel.link: convenient data exchange with Microsoft Excel
xl.current.region

Read/write from/to Excel current region.
xl.write

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

Basic operations with Excel workbooks
xl.sheet.add

Basic operations with worksheets.
xl.read.file

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

Functions from RDCOMClient package