Using excel.link package in Real Time Environment

Mon, Jun 22, 2015 11:19 PM #

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