Re: [Rcom-l] what about the book "R through Excel" ?

have a look at this url and the directory containing it http://rcom.univie.ac.at/download/devel/book-Jan14-erich-ann.pdf MICHELE DE MEO írta: As reported by this page: http://astro.temple.edu/~rmh/HH/ I understand that in 2009 will be available the book: R through Excel Introductory and Advanc

Re: [Rcom-l] MiKTeX.session

I'm afraid at the moment it is not possible. In the first case the com method fills the path value into an [out] parameter of the method, which is discarded by the C function com_invoke. One possibility would if the [out] parameters (or all of them) are attached as an attribute to the return

Re: [Rcom-l] Counmarshalinterface and datetime once more

lue2 property of the cell, and it seemed to me that this not needed any more. Of course if finally this facility will be available, without the present limitation I will use it. Thanks for your work on the rcom/rscproxy package, they are very useful. Best wishes Vilmos Thomas Baier írta:

Re: [Rcom-l] Counmarshalinterface and datetime once more

Thomas Baier írta: Dear Vilmos, Prokaj Vilmos schrieb: I downloaded the new version, thanks for incorporating the changes to the main stream. I still see a possible error in the bdx_com.c file, although it did not cause any problem to me. The other portion of the code using

Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still

The latest rscproxy is 1.0-12. 1.0-11 is buggy. Wait for the compiled binary or compile yourself from sources. I could download this morning the source of the new version from the austrian mirror of CRAN. Murray Eisenberg írta: I have R 2.8.0. In its library I have the latest rcom (2.0.4) and

[Rcom-l] Counmarshalinterface and datetime once more

Dear Thomas, I downloaded the new version, thanks for incorporating the changes to the main stream. I still see a possible error in the bdx_com.c file, although it did not cause any problem to me. The other portion of the code using counmarshalinterface of windows api is the BDXGenericArray2V

[Rcom-l] stack inbalance when getting date value

Dear Thomas, In the following lines of code the activecell contains a date/time value XL<-comGetObject("excel.application") a<-XL[["activecell"]] a[["value"]] Warning: stack imbalance in '.Call', 16 then 17 Warning: stack imbalance in '{', 14 then 15 Warning: stack imbalance in '[[', 2 then 3 [1

[Rcom-l] Passing a COM object pointer does not work in the new rcom package

Dear Thomas, I think I finally catched the bug. In the bdx_com.c file in the BDXScalar2Variant function the BDX_HANDLE case was handled in the following way: case BDX_HANDLE: { LPSTREAM lStream = pBDXData->data.raw_data[0].ptr; void* lTmpPtr = (void*) V_DISPATCH(pVariantD

[Rcom-l] Passing a COM object pointer does not work in the new rcom package

Dear Thomas, I switched to R-2.8.0, and I had to realize as others also reported in this mailing list, that under R-2.8.0 the rcom package does not work properly. My concrete problem was that the following code (a similar to that one) caused a crash of R. XL<-comGetObject("excel.application

Re: Fwd: [Rcom-l] Offline installation

Dear John, I found the following possible reason. I don't use the latest version, but in a similar manner you can find the reason. Rexcel defines a few form, which you can inspect through the VBA editor. One of these forms is the serverform. On this form the setserverfromregistry subroutine set

Re: [Rcom-l] (no subject)

Hi, I have used this once (r is a range object) racsozas<-function(r){ r[["Borders",5]][["LineStyle"]] <- as.integer(-4142) r[["Borders",6]][["LineStyle"]] <- as.integer(-4142) for(i in 7:10){ r[["Borders",i]][["LineStyle"]] <- as.integer(1) r[["Borders",i]][["Weight

Re: [Rcom-l] RExcel with ESS

Hi Scott, Try to load the rcom package in the ESS terminal before connecting from EXCEL. Scott Stephens írta: Greetings, My preferred way of using R at the command line is through Emacs with the ESS add-on. I would love to be able to use RExcel with ESS in the same way that it's possible

Re: [Rcom-l] C# importing data from database and analyzing it with R

Ben Brooks írta: Greetings! I am trying to use C# to interface with [R]/DCom server for data analysis and our database. I am having trouble getting data into the [R] engine through the DCom server as my results are not the same as if I using the odbc connector and [R]. Below is my code. I am t

Re: [Rcom-l] Save output of character device

Julien Vanwinsberghe írta: Dear all, I’d like to save in a log the R output (from the R ‘print’ function by example) that we can see when an AxStatConnectorCharacterDevice control is connected to a StatConnectorClass object. Is there a method to access the text printed on the character devi

Re: [Rcom-l] Closing Excel using rcom

Hi all COM objects of the EXCEL appl. i.e. wbk too sould set to NULL and a garbage collection gc() will release the objects. Vilmos Volchik, Yuri írta: Hi to all, I read some emails regarding closing of Excel from R using objExcel.Quit but it still not working for me. Does anybody ha

Re: [Rcom-l] RExcel Background Server Config & library(tkrplot)

Hi, still for the problem of short path names. The following code works with background server and forground server too. env<-environment(.libPaths) assign(".lib.loc",shortPathName(get(".lib.loc",envir=env)),envir=env) library("tkrplot") Vilmos [EMAIL PROTECTED] írta: Hi RExcel users, I am

Re: [Rcom-l] RExcel Background Server Config & library(tkrplot)

Hi, At the moment I see what went wrong, with no idea how to correct it, or what causes this behaviour. The .First.lib function of this package contains the following lines file <- system.file(path, package = pkg, lib.loc = lib)[1] .Tcl(paste("load", file, "Rplot")) where the values of

Re: [Rcom-l] Excel VBA Error

Hi, in the line Call RInterface.RRun("setwd(""D:\Program Files\R\(D)COM Server\xls"")") try either \\ or / instead of a single backslash \ . Vilmos Prokaj Uma Sitaraman írta: Hi, I am having a problem reading data between R and Excel. I have saved my code in file: lastsave.txt, an

rcom-l@mailman.csd.univie.ac.at

You probably wanted to write Call rinterface.RRun("source("""& ThisWorkbook.Path & "\temp.r"")") In VBA "" stands for " inside a string Vilmos Prokaj Felipe Carrillo írta: Hi: I can't make the code below work,can someone tell me what I am missing? Call rinterface.RRun("source(ThisWorkbook.Pa

Re: [Rcom-l] RExcel installation woes and suggestion

you are absolutely right. Thomas Baier írta: If I can suggest this code, it would be if(require(rcom)){ comRegisterRegistry() comRegisterServer() unloadNamespace("rcom") } Very bad idea. comRegisterServer() is called automatically on loading rcom, comRegisterRegistry() should

Re: [Rcom-l] RExcel installation woes and suggestion

If I can suggest this code, it would be if(require(rcom)){ comRegisterRegistry() comRegisterServer() unloadNamespace("rcom") } Erich Neuwirth írta: RExcel works both with the DCOM server and the rcom server. Therefore, it cannot automatically install rcom. I might add some code to check

Re: [Rcom-l] rcom use multibyte string in japan

I had something similar with hungarian umlauted characters before. The solution for my problem was that in the regional setting advanced tab( I think this is the name used in the english version of WINXP) I set the language for non unicode compatible programs Probably this will help you too.

Re: [Rcom-l] rcom problem: Server not available

Hi have you tried to register the rcom server from R At the R console you should give the following command >require(rcom) >comRegisterServer() >comRegisterRegistry() probably this can help. Vilmos Prokaj sakib mondal írta: Hi, Sorry, I could not test this earlier. However, I am facing the

Re: [Rcom-l] re: rcom erros

hello Allan have you check that what contains your Data.x? The function leaps.setup contains some Fortran call and the first of these has the fourth argument: t(xx) where xx is a subset of your Data.x. If it contains some Na that can cause the problem. Probably there are some empty cell in the

Re: [Rcom-l] Macro RExcel help

-libor[i-3]/12 } qreturn ts(residuals(garch(qreturn, c(1,1))),frequency=12, start=c(1980,4))}") It seems does not work. Any advice? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

Re: [Rcom-l] Resources for calling Excel from R

I resend this message. This was sent previously in reply to another message. Hi, I use rcom in a similar way as you plan to do. I usually start with Visual Basic of Excel. Then I simply translate the VBA code to R code (macro recorder could help a lot, and for the contants there is the built in

Re: [Rcom-l] Macro RExcel help

not sure how to set the R server to be a foreground server etc. I am really grateful for your further help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prokaj Vilmos Sent: Wednesday, November 14, 2007 1:25 PM To: R (D)COM and RExcel server related issues S

Re: [Rcom-l] Macro RExcel help

írta: I added an "s", it seems not because of that. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prokaj Vilmos Sent: Wednesday, November 14, 2007 12:59 PM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Macro RExcel help

Re: [Rcom-l] Macro RExcel help

I resend this message, as my other account seems to be very slow. Hi, I use rcom in a similar way as you plan to do. I usually start with Visual Basic of Excel. Then I simply translate the VBA code to R code (macro recorder could help a lot, and for the contants there is the built in object brow

Re: [Rcom-l] Macro RExcel help

Hi You have made a typo in the last line lm has coefficients member, an s is missing Vilmos Prokaj Sub Rreg() Call Rinterface.StartRServer Call Rinterface.RunRFile("C:\Documents and Settings\Y\Desktop\function") Call Rinterface.RRun(" variableSEN_gbl <- devar(tblLiquidity2,'SEN_gb