Starting rcom automatically
It is useful to start rcom whenever RGui is started. Then, one can start Excel later and have it communicating with R.
To do this, the file
has to contain the line
Using rcom to access from R applications other than Excel
dBank is an excellent time series database designed by Philip Ouliaris It is accessed via COM from VBA and other languages.
We are not interested in the Excel add-in, could we manipulate it directly from R?
How to access if from R?
x ← comCreateObject(“DbankEngine.dbTimeSeries”)
work nicely, but what else?
In Windev we can do:
y is object Automation “DbankEngine.dbTimeSeries”
y»Frequency = “Q”
#Fill time series y
j is int
FOR j = 1 TO y»Nobs
How to get the same output with rcom?
comInvoke(y, “Read”,“F\\Dbank32\\example[ace]a”) returns NULL
which is not useful.
The R help for rcom has not examples of use from within R.