[R] RExcel : problem with error handler?

Prof Brian Ripley ripley at stats.ox.ac.uk
Wed Oct 6 12:40:10 CEST 2004


Please note, this is R-help.  The mailing list for help with RExcel (which
is not part of R) is given on
http://cran.r-project.org/contrib/extra/dcom/RSrv135.html as
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l

On Wed, 6 Oct 2004, Matthew Dowle wrote:

> 
> Dear R-help,
> 
> Call RInterface.StartRServer      ' Works fine
> Call RInterface.RRun("objects()")		' Works fine
> Call Rinterface.RRun( other R commands which do not generate errors, the
> demos etc ) 	  ' Works fine
> But ...
> Call RInterface.RRun("doesnotexist")	' Sends Excel into endless loop it
> appears
> 
> After about 90 seconds a dialog box appears  "Microsoft Excel is waiting for
> another application to complete an OLE action".  Click OK then it hangs for
> another minute or so, and displays the dialogue again. Task manager is
> required to kill Excel.  I rebooted to ensure only Excel is running, so
> there should be no conflicts with any other app, but the same error is
> repeatable. In this case I was expecting the R error "Object "doesnotexist"
> not found" be passed back into Excel, either as a dialogue box in Excel, or
> available to VBA using a GetRError function or something?
> 
> I hope someone can help, or point me in the right direction.
> 
> Info from "About RExcel" :
> 
> RExcel version 1.35
> RDCOM server 1.35
> R system software: Version 2.0.0
> Microsoft Excel 10.0
> Windows NT 5.01
> 
> > version
>          _              
> platform i386-pc-mingw32
> arch     i386           
> os       mingw32        
> system   i386, mingw32  
> status   beta           
> major    2              
> minor    0.0            
> year     2004           
> month    09             
> day      28             
> language R              
> > 
> 
> Many thanks,
> Matthew
> 
> 
> 
> 
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> 
> 

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595




More information about the R-help mailing list