similar to: D(COM) with Excel

Hello all Can R be used as a COM client (rather than as a COM server)? The following (Splus) code shows the sort of thing I'd like to do: pMIM <- create.ole.object("mim31.Server") NoOutputLines <- call.ole.method(pMIM, "SendCmdLine", "show w") for (i in 1:NoOutputLines) show(call.ole.method(pMIM, "GetOutputLine")) release.ole.object(pMIM)

Dear list member, I am using the packages RDCOMClient and SWinTypeLibs and try to import a COM object (created in Delphi) in R that is of type 'early binding' instead of late 'late binding'. Is there a possibility to do this in R? Currently, the following returns an error message: l1 = LoadTypeLib("c:\\Programme\\INVESCO\\QaCalendar\\Calendar.dll")

Greetings everyone, I am new at R. My questions is rather basic. Looking R manuals looks like there should be a way to read MS excel files into R. Could somebody tell me which library should I use for that? Thanks in advance Victor H. Marín Laboratorio de Modelación Ecológica Depto. de Ciencias Ecológicas, Fac. de Ciencias, Universidad de Chile Casilla 653 Santiago, Chile

Has anyone managed to get this working? Here's what I did: I got the binary build for R2.0.1 from the Omegahat download page, and made a small change to the registerClassID function ( to make it use the right path to RDCOMServer.dll). Then I tried to replicate the simple TTest example from the same web site. The COM class definition and registration worked fine for me. To test this, I

Hi Everyone, I'm experimenting with the RDCOMServer package under R-2.0.0. I'm not having much success yet - the methods im registering do show up in the registry but I'm not able to call the using RDCOMClient from another package. I'm still attempting to diagnose my problem in other ways, but though I should check to see if there are any problems have been observed by others

Dear all, i use the following package/syntax to export data to excel: library(xlsReadWrite) write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) Everything is fine, but the format of the export is not the best. For example, I every time have to adjust the column width. Furthermore there is no possibility to highlight some cell or make them colourful. I create a lot

Hello I am using Duncan Lang's RDCOM Client package (available on omegahat.org) under R 1.7.0 and Windows XP Pro. Is this the right forum for questions about this package? In case it is, here is my question: Instances of COM objects do not seem to terminate as expected, but leave residual processes running. For example, if I try the simple example: E <-

Dear All, I am using excel.link package to open and modify Excel files. When I manually open Excel, all my add-ins are loaded without a problem. But when I open Excel using excel.link package, like: xls<-xl.get.excel() xl.workbook.open("MyFile.xlsx") some Excel add-ins are (installed but) not loaded. Since the problem is related to local add-ins at my side, I cannot reproduce the

I am trying to use R functions from my MATLAB code using a DCOM server. I am working under Windows XP. While I mange to run basic functions and run them using scripts, when I try a more complicated set of functions I fail. I am trying to perform survival analysis, using Surv Surv(recruTime,recur) Surv creates a somewhat complex output and I get the response Problem evaluating command

Dear List, I have unregistered the working installation of R(D)COM from r1060 as described in http://cran.r-project.org/contrib/extra/dcom/ReadMe.txt, and have re-installed it for r1070. Now, vbtest gives the following message: Loading StatConnector Server... Done Initializing R...Function call failed Code: -2147221485 Text: installation problem: unable to load connector Box: Method

I have finally got around to putting 4 packages on the Omegahat web site for use on Microsoft Windows. The packages are: RDCOMClient - interactive, dynamic access to arbitrary (D)COM objects from within R that allows one to create COM objects from R and call their methods and access their properties without the need to compile any code specific to the COM object. RDCOMServer - facility for

I have Excel files containing data that I would like to move to R. They are in the standard form of a one row header followed by rows of data, one record per row EXCEPT that there are a few rows of comments before the header. The number of rows of comments varies. For Excel files of this form without comments I have had success with: require(RODBC) z <-

Where I work a lot of people end up using Excel spreadsheets for storing data. This has limitations and maybe some less than obvious problems. I'd like to recommend a uniform way for storing and archiving data collected in the department. Most of the data could be stored in simple csv type files but it would be nice to have something that stores more information about the variables and units.

I have been doing data analysis/modeling in R, connecting to SQL databases with RODBC (winXP client with R1.9.0 and win2k SQL server 2000). I am now trying to leverage some of the OLAP features to keep the data intensive tasks on the DB server side and only keep the analytical tasks within R (optimize use of memory). Is there any package that would allow to connect to OLAP cubes (as a client

In R, How to read Excel file and access the data item? Thank you. --------------------------------- [[alternative HTML version deleted]]

Dear all, In S+, there are functions like create.ole.object call.ole.method release.ole.object for communicating with other programs which work as a COM server (on Windows). Is it possible to do something similar in R (I've studied the 'connections' facilities, but they do not seem to work). ========================================== S?ren H?jsgaard, PhD, Senior Scientist

Hi, We - Venkatesh Mysore and Salvatore Paxia of the New York University's Bioinformatics Group under Prof.Bud Mishra - have been working on enhancements to R for a while now. We're happy to announce that we have some good stuff up and running now: 1. A debuggable Microsoft Visual C version ( _MSC_VER) of R-1.7.0: R-1.7.0-msc (YES !!!!) 2. COM/OLE-support that will allow invoking of

Dear all, I am quite new to R and for preofessional reasons I was interested in the R/excel interface by Baier and Neuwirth. After setup I see the Rexcel and the Rhelp on the Menu bar of Microsoft Excel XP. However, after putting the formula =RApply("pchisqr", 30, 1) Excel returns the message "could not start Rserver". Any suggestions how to fix this. How do run this

Dear R Developers, A recommendation for future development. It would help if R scripts could be compiled into an executable, or a library. Speed is the main issue (I run a large scale monte carlo in R which is very slow). However, it would also make it easier to link R into other applications, easier at least than the COM infrastructure under Windows. Finally, it would make it much easier to

Full_Name: Joel Pitt Version: 1.81 OS: XP Submission from: (NULL) (218.101.45.243) Running any of the windows binaries in Windows XP cause programs to immediately exit without producing any error. The RGui is displayed momentarily and everything looks fine before it exits. Attaching Visual C++ to either of Rgui or RTerm results in the following: "User breakpoint called from code at