Hello there,
I started to use rcom package and there were no problems until I tried to
call some external function (method) which returns safearray type of data
where either me or rcom or something else fails. Specifically I connected to
a database and called a method doing something like this
require(rcom)
V8-comCreateObject(V81.COMConnector)
con-comInvoke(V8,Connect,File=K:/)
result-comGetProperty(con,ExternalFunctions)
result$Test()
which returned me just NULL. I tried to call the same method from excel vba
by doing
Set V8 = CreateObject(V81.COMConnector)
Set con = V8.Connect(File=K:\)
result = con.ExternalFunctions.Test()
ActiveSheet.Range(A1, Cells(UBound(result, 2) + 1, UBound(result, 1) + 1))
= WorksheetFunction.Transpose(result)
which returned me what I expected to be returned - some kind of data.frame
with symbols and numbers.
Does anyone have any idea how one can retrieve such kind of data in R?
I use the latest rcom 2.2-3.1 (tried both precompiled one and compiled from
tar.gz).
Many thanks in advance!
Kind regards,
Alex
--
View this message in context:
http://r.789695.n4.nabble.com/rcom-and-safearray-type-of-data-tp2548552p2548552.html
Sent from the R help mailing list archive at Nabble.com.
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.