similar to: R and Excel question

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

Hi, I have some questions about Excel-to-R interface and I hope somebody can help me. Is it possible to call functions in a self-defined package from Excel using the Excel-to-R interface? We created the package successfully and can run all the functions inside R. But when we tried to run them from Excel, we kept running into problems. It seems we can not run anything that is not in the base

I am trying to learn the basics of Sweave so I read some things and a friend gave me his Rnw file to play with. I am able to do R CMD Sweave mark-example.Rnw. That works. But, then when I do latex mark-example.tex, I get the message below. I looked in the archives and Martin Morgan mentioned something in 2004 in terms of making sure that latex is looking at where Sweave.sty is but I am unsure

Hello everybody, at work I want to start R within an VBA program. First I calculate something in Excel 2003. After that I want to start within my VBA makro R wich should start an R file, say i.g, superplot.R which plots me the data well. So is it possible? Maybe something like that: sub test() 'calculate something start R superplot.R end test() Thank you so much. Kindly

I have a highly formated Excel with multiple tabs. Is it currently possible to read this data into R without changing the format of the Excel file? Also, is it possible to write back to the same Excel file or at least create a new Excel file with the same formatting as before with modified data which has been processed in R. Thanks in advance for any help that you can provide. Dave

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 <-

The system is FC4 with the latest upgrades installed. Wine is 0.9.5. The latest wine is doing the best at running Office in a long time. Word seems very stable. That said excel is hanging on the splash screen. This in an old symptom that keeps re-occurring. DCOM is installed correctly. Does anyone know what the cause of he splash screen excel is? Thanks - Dan

Dear R-help, Call RInterface.StartRServer ' Works fine Call RInterface.RRun("objects()") ' Works fine Call Rinterface.RRun( other R commands which do not generate errors, the demos etc ) ' Works fine But ... Call RInterface.RRun("doesnotexist") ' Sends Excel into endless loop it appears After about 90 seconds a dialog box appears "Microsoft

If I have the string below. does someone know a regular expression to just get the "BLC.NYSE". I bought the O'Reilley book and read it when I can and I study the solutions on the list but I'm still not self sufficient with these things. Thanks. stock<-"/opt/limsrv/mark/research/equity/projects/testDL/stock_data/fhdb/US/BLC.NYSE"

I have a question related to scoping. Suppose we have 2 functions: f1 = function(i){i = 1} f2 = function(n){ i = length(n) f1(i) } In other words, I would like i=1 regardless of n. Is this possible without having f1 in the body of f2? Thanks in advance!

Hi Everyone: I've been going through Alan Lenarcic's package tutorial but when I did R CMD SHLIB Xdemo.cc Xdemo_main.cc -o Xdemo.dll I got the following error: XDemo_res.rc:15:38: warning: missing terminating " character XDemo_res.rc:23:34: warning: missing terminating ' character c:\mark\research\Rtools\MinGW\bin\windres.exe: XDemo_res.rc:16: syntax error

Hi! I am trying to display a graphic using the dcom server and the dcom graphics object. Works fine without the embedded graphics object, in it's own windows, but if i use the embedded object (what I need to do) the colors are gone. Graphics are always only black and white. Even in the DCOM examples for VB the graphics are without color - is this a bug? Can I do anything about it?

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my

Using Thomas Baier's DCOM server I can do the following (in Windows 2000): I create a slider in Excel, and the sliders On_Change event triggers a call to R. This call redraws an R graph, and so I have animated R graphics controlled by Excel's slider. The problem is that Excel needs focus so i can grab the slider, and therefore it partially covers R's graph window. Is there a way to

hi everyone : i'm not sure if my previous mail about this got sent. i was typing and erroneosuyl hit a button and lost what i was typing. anyway, i have the code below ( it works ) in which i run through the rows of a dataframe, taking out the first two fields which are characters strings ( with some extra spacing so i yuse gsub) and appending these character strings to a list so that i can

Hello evry one, I'm a frensh consulting Engineer in statistics and i work under R times to times. I would like to build an Graphic User Interface as we can do under MS Excel but i don't know how to do it. The aim is to have a GUI betwen a user and the console or the function (for exemple toto(a,b,c) ) In the GUI , i would like to have 3 boxes empty where i can put the values of a, b, and

>From: markleeds at verizon.net >Date: Thu Jul 06 13:16:42 CDT 2006 >To: markleeds at verizon.net >Subject: as.data.frame question >hi all : as a result of an lapply command, >i get the following output. > > >$AAA > 000106 000107 000108 > 5.5 6.5 3.0 > >$BBB > 000106 000107 000108 > 4 5 6 > >$CCC

Hello to all, How can I make R read the data from an Excel sheet? thanks, ozlem [[alternative HTML version deleted]]

some of you might be interested. i just uploaded the first release of my r-excel interface package to CRAN. it is in contributed extensions nonstandard extensions erich neuwirth -- 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

some of you might be interested. i just uploaded the first release of my r-excel interface package to CRAN. it is in contributed extensions nonstandard extensions erich neuwirth -- 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