Hi,

 

I am hoping you may be able to help please?

I am trying to use R Excel to run an R script using
"RInterface.RunRFile"

I have tested this command on basic scripts and they work fine. However
when I try to run quite a long script which runs a number of forecasts
using the forecast package, linear regressions and then tries to print
and excel workbook I get the error

Microsoft Excel is waiting for OLE action. It also opens a box that says
R graphics. Both of which I can't get rid of and have to terminate
excel.

 

The script works fine in R, although it takes about 8-10 minutes to run
as it is on a lot of data and runs a number of things. But it does work
fine.

I wonder if it is the fact that the script takes so long to run that
excel gets lost waiting for R to do its thing....

 

I was hoping if someone may be able to offer help please? If someone has
had a similar problem which they were able to solve?

 

Or alternatively any idea of how to run an R script without the use of R
Excel please? - through the command line?...

 

Thank you for your help


Alex

 

 

Alex Johnson

Operational Research Analyst

The AA

 

Automobile Association Developments Limited. Registered office: Fanum
House, Basing View, Basingstoke, RG21 4EA. Registered in England and
Wales Number: 01878835 

 

"To our Members we're the 4th Emergency Service"
This electronic message contains information from The Au...{{dropped:17}}

