[R-SIG-Finance] Using excel.link package in Real Time Environment

Kunal Shah kunalshah305 at gmail.com
Tue Jun 23 08:19:22 CEST 2015


I used excel.link package in *R*

   1. Imported data *D* from excel using xl[[MyRange]]
   2. Done some manipulations on the data
   3. Exported data ModifiedD from *R* to Excel using the same
function xl[[MyNewRange]]


It is working fine. Results are displayed properly but sometimes it gives
the following error
Error in xls[["Visible"]] : Cannot locate 0 name(s) Visible in COM object
(status = -2147418111)

Then when I again run R, it works properly
Regards

	[[alternative HTML version deleted]]



More information about the R-SIG-Finance mailing list