excel.link
Software:119354
CRANexcel.linkMaRDI QIDQ119354
Convenient Data Exchange with Microsoft Excel
No author found.
Last update: 17 January 2024
Software version identifier: 0.9.10, 0.9.11, 0.5.2, 0.5.4, 0.5, 0.6, 0.8.1, 0.9.1, 0.9.3, 0.9.4, 0.9.5, 0.9.7, 0.9.8-1, 0.9.9, 0.9.12
Copyright license: GNU General Public License, version 3.0, GNU General Public License, version 2.0
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.
