similar to: r-excel interface code

Hi, I'm trying to combine a VBA macro and a R package. I've installed the R-(D)COM and the R-excel interface by Neuwirth. They seem to work both. However I would like to display the r-generated data in an Excel sheet as an array but I don't manage. Here is an example of my source: Sub doR() Call RInterface.StartRServer Call RInterface.RRun("library(mdnn)") Call

I wrote a R script say called computeCovarMatrix.R and i want to call and run this piece from Excel visual basic. does anyone know how to do that? thanks, KZ [[alternative HTML version deleted]]

In the windows version (RGui), is there a way to set the text displayed in the titlebar of the R window? When I have 2 instances of RGui running, it would be helpul if the titlebar could help to understand which is which. -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386

hist(rbinom(1000,10,0.5),col=2,xlim=c(0,10),ylim=c(0,300)) gives a histogram with "touching bars" hist(rbinom(100000,10,0.5),col=2,xlim=c(0,10),ylim=c(0,30000)) gives a histogram with space between the bars. is there a way to control the space betweent he bars easily? -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at

typeof applied to a factor always seems to return "integer", independently of the type of the levels. This has a strange side effect. When a variable is "imported" into a data frame, its type changes. character variables automatically are converted to factors when imported into data frames. Here is an example: > v1<-1:3 >

In some languages there is a function gensym() which returns a new unique name (in the current environment). This is quite helpful when one has to do temporary assignments. I could not find such a function in R. Is there one? -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386

doing make -f Makewfile.win test-Internet in tests gave make[1]: Leaving directory `/cygdrive/d/Work/R-devel/tests' D:/Work/R-devel/bin/Rterm --vanilla LC_ALL=C --internet2 --vanilla < internet.R > internet.Rout2 diff internet.Rout internet.Rout2 99,100c99,100 < unable to resolve 'foo.bar'. < Error in url("http://foo.bar", "r") : cannot open URL

i want to call "c:/Program Files/Netscape/Communicator/Program/netscape.exe" with system but system("c:/Program Files/Netscape/Communicator/Program/netscape.exe") does not work because of the blank. system('"c:/Program Files/Netscape/Communicator/Program/netscape.exe"',wait=FALSE) works exactly like i want. when i set options(browser="c:/Program

i am using the rarcinfo package to draw maps. for maps, th aspect ratio is quite important. how can i control the aspect ratio and the size of a graphics window in the mswindows version of R and more generally in R in general. i would like to e able to both set the size before or while the window is corrected, and also for a window which already exists. -- -- Erich Neuwirth, Computer Supported

Dear all, I have recently experienced something with the function order I cannot explain: The help(order) (which I admit having overlooked before) rises even more my confusion... The following lines made me think order() was returning the 'order' each value in a vector would take when sorted. > a <- c(4.1, 3.2, 6.1) > order(a) [1] 2 1 3 Doing > plot(a,

RColorBrewer 0.1-1 is available on CRAN. The packages provides palettes for drawing nice maps shaded according to a variable as an R function. The palettes have been designed by and are copyrighted by the ColorBrewer project. An interactive palette selection tool byt the original designers is available at http://colorbrewer.org -- -- Erich Neuwirth, Computer Supported Didactics Working Group

RColorBrewer 0.1-1 is available on CRAN. The packages provides palettes for drawing nice maps shaded according to a variable as an R function. The palettes have been designed by and are copyrighted by the ColorBrewer project. An interactive palette selection tool byt the original designers is available at http://colorbrewer.org -- -- Erich Neuwirth, Computer Supported Didactics Working Group

with todays r-devel..tar.gz make distribution hangs on my win98 machine. this is the las message i see MAKE[2]: Leaving directory `/cygdrive/c/devel/R-devel/src/gnuwin32/bitmap/jpeg-6 b' cp Rbitmap.dll ../../../bin MAKE[1]: Leaving directory `/cygdrive/c/devel/R-devel/src/gnuwin32/bitmap' after that, the it seems that sed is running and somehow hangs. i do have the tools from brians

Full_Name: Hannu Kahra Version: 1.0.0 OS: Windows Submission from: (NULL) (153.1.50.127) x1 <- lag(x, k=1) returns the original series x. The time series is not shiftet at all. Only the time is shiftet: for x1 new start = old start -1 and new end = old end -1. When I run, e.g. lm(x~x1) the result is not what I expect. Both x and x1 are time series. Is this a bug or am I forgetting something?

R 1.4.0 is now sinking into feature freeze, and we'd like some help testing it under Windows. Duncan Murdoch and Uwe Ligges have already volunteered. I've put a copy of SetupR140.exe at http://www.stats.ox.ac.uk/pub/bdr/RWin Also in that directory is a file TESTING suggesting some tests, not all of which have been run on this build. As the graphics internals have been changed a lot

I have a big contingency table, approximately of size 60*2*500*500, and I need to count the number of cells containing a count of 1 for each of the factors values defining the first dimension. Here is my attempt: tab1<-with(pisa1,table(CNT,GENDER,ISCOF,ISCOM)) tab2<-apply(tab1,1:4,function(x)ifelse(sum(x)==1,1,0)) tab3<-apply(tab2,1,sum) Computing tab2 is very slow. Is there a faster

Dear R users, I've just posted a similar question about Illustrator. This time I would like to export the results of my statistic tables and my dataframes into Excel files. Up to now I've used write.csv(), but I have to resave every file in .xls in Excel. I would like to know if there is a function or package to export directly into *.xls. I have found xlsReadWrite which would be

Isn't anything in a data frame that is not explicitly numeric a *factor*? -Greg > -----Original Message----- > From: Peter Dalgaard BSA [mailto:p.dalgaard@biostat.ku.dk] > Sent: Friday, December 07, 2001 5:32 PM > To: Erich Neuwirth > Cc: r-devel@stat.math.ethz.ch > Subject: Re: [Rd] question > > > Erich Neuwirth

Hello!!! I have been read a much about as read data from Excel File, but I haven?t found the necesary information to read the data. Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I don?t know as read the data?? I hope that you could help me. Thank you very much. -- View this message in context:

I would like to write a stand-alone application (in C) using R's statistical and graphical capabilities. To make it more challenging I would have to do it using Windows 2000 platform. I seem to remember that R can be compiled into a library of subroutines and linked to an external program. Is this true or is my memory playing tricks on me? I scanned the FAQs and the "extensions"