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.
