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 <email@example.com>. To comply CRAN policy includes source code from 'RDCOMClient' (http://www.omegahat.net/RDCOMClient) by Duncan Temple Lang <firstname.lastname@example.org>.|
|Date of publication||2016-09-24 22:50:55|
|Maintainer||Gregory Demin <email@example.com>|
|License||GPL (>= 2)|
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