search for: rexcelinstaller

RExcelInstaller_2.0-15 installs RExcel, an add-in for Excel, which connects R and Excel. RExcel allows to transfer data between R and Excel, writing VBA macros using R as a library for Excel, and calling R functions as worksheet function in Excel. RExcel integrates nicely with R Commander (Rcmdr), turning R Comm...

Hi community. I'm fairly new to R and have a basic question. When I try to install RExcel with the code: install.packages("RExcelInstaller", "rcom", "rsproxy") I get the message below: Warning in install.packages("RExcelInstaller", "rcom", "rsproxy") : 'lib = "rcom"' is not writable Error in install.packages("RExcelInstaller", "rcom", &quot...

...RInterface.StopRServer ActiveWorkbook.Save End … obtengo el siguiente error “Error de compilación No puedo encontrar proyecto o biblioteca”. He revisado los addin de VSB y todo parece correcto. Revisando la web vi que desde RProject tenía que correr este código: install.packages("RExcelInstaller", "rcom", "rsproxy") y pensé que esto podía ser la solución. Pero resulta que me dice que no los puede instalar porque el archivo no es writeable. En definitiva que llevo varias semanas con este tema y por desesperación he desinstalado todo. Os quería por favor pedi...

Hello, I just installed RExcel but I have some problems. I am writing you the set of commands that I used: > install.packages("RExcelInstaller", "rcom", "rsproxy") > library(rcom) > comRegisterRegistry() > library(RExcelInstaller) > installstatconnDCOM() > installRExcel() But when I select RStart from add-ins I see this written "No R server configured. Please set Rserver to work with RExcel&qu...

...g' I thought of using sqlSave in the same package, but it does not work (I think because this function starts from an existing file). Is there a workaround for this, or are there other plausible options for writing .xlsx files? With kind regards, Katrien PS: I found some information about RExcelInstaller, if this is something that would solve my problems could someone describe how it works (the user manual did not help me very much). -- Katrien Baert Statistical Consultant IOF valorisatieconsortium Stat-Gent T 32 9 264 47 66 http://www.statgent.org/

Hi, I was trying to run your code in my VBA editor, however could not succeed. The execution stumbled in the line "Call Rinterface.StartRServer" itself. I have RCOM package installed into my R environment. Do I need to install anything else to run that? Would guys here guide me? Thanks -- View this message in context: http://n4.nabble.com/R-Excel-Macro-Problem-tp858831p1592196.html

Hi, I am installing Excel using package "RExcelInstaller". When I tried to run installRExcel() I got this error message: You don not have the R package rcom installed. The (D)COM server installed which will aloow you to use the background server in RExcel. Since rcom is not installed, foreground mode will be unavailable. You may continue with...

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:

Dear all,   I was using older version of R (installed early). I install new version of R (R.2.9.0) but i could not find package "xlsReadWrite" to read Excel file. Is there any alternatives to read Excel file ? I hope it should be. I need help although it is minor querry. Thanks in advance.   Sincerely, Ram Kumar Basnet Wageningen University, The Netherlands   [[alternative HTML

Struggled a whole day, but still could not get DCOM working on my machine. What I did is: 1. Installed R 2.8.1 under folder "../R/R-2.8.1" 2. Installed R_Scilab_DCOM3.0-1B5 under folder ".. \R\(D)COM Server" 3. Installed packages: rscproxy_1.0-12, RExcelInstaller_3.0-10, rcom_2.0-4... 4. run the following commands: library(rscproxy) library(rcom) comRegisterRegistry() library(RExcelInstaller) installRExcel() Problems: 1) Got error message when I run "installRExcel()", which was "The download site h...

...ed it to get the summary coefficients table from lm() into Word nicely. Once it is in Word, it is easy to change the format of the table to your "standard" format. This is a very new package but there's certainly lots of potentials in it. Another package that might be useful is the RExcelInstaller, which gives an integration of R and Excel (again, Windows version, I believe). I've used it to call R from Excel directly. Cheers Kev Kevin Wang Senior Adviser, Government Advisory Services Advisory KPMG 10 Shelley Street Sydney NSW 2000 Australia Tel +61 2 9335 8282 Fax +61 2 9335 7...

...as the use of role= to signal the creator and maintainer. - a comment to see ?person for descriptions of fields wouldn't hurt either best, -Michael On 8/8/2011 9:46 AM, Kurt Hornik wrote: > Dear maintainers, > > This concerns the packages > > CITAN ENmisc Formula MSBVAR RExcelInstaller RcmdrPlugin.mosaic > Rd2roxygen Rz SGP betareg expectreg fastcluster glmc gptk heplots pxR > sideChannelAttack sp spacetime trapezoid vcd > > maintained by one of you. > > I see that you have added Author at R fields providing enhanced information > on package authors t...

Hi R, I have a an excel file with a lot of data. I need to create an user interface in R, which has one single screen. It needs to contain a right pane containing the click buttons for different countries (say). If the user clicks a country, then a chart needs to be created for that country, taking the data from Excel. Is this possible and which package helps me in doing this? Many thanks in

I am reading dates in Excel2007 into R. Here are the functions I used: library(RODBC) channel<-odbcConnectExcel2007("myfile.xlsx") tmp<-sqlFetch(channel,"1",as.is=T) The dates in myfile.xlsx are all in this format: mm/dd/yyyy. But when I read it to R, some columns look like "yyyy-mm-dd 00:00:00", some columns look like "yyyy-mm-dd", and some

Hi I am looking for R templates to introduce the R to my students at Seton hall university. The templates are predefined scripts in R that will retain its primary intent when individually customized with their own variable data or text. In this case, my students at Seton Hall University. For example, PSPad editor provides new users predefined templates before writing their own scripts. Please let

What is the syntax for this? If you have: vector = c(1,2,3,4), how would you output this to column A of an excel spreadsheet? -- View this message in context: http://r.789695.n4.nabble.com/how-to-you-output-a-vector-to-a-column-in-excel-tp2530470p2530470.html Sent from the R help mailing list archive at Nabble.com.

Even using the VBA back of Excel to create interfaces with R would make a lot of sense. Suppose I could have access to VBA macros that import and export data into R , it would be great. The R GUI series like Rattle come even closer to Excel...so a VBA _R_ExCel package might be useful to ordinary folks . Besides Excel costs money, so adding R functions to Open Office would help both of them ( if

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

...3), rattle (2.5.35), rbugs (0.4-3), rcdk (2.9.23), rcdklibs (1.3.4.2), Rcmdr (1.5-6), RcmdrPlugin.DoE (0.6-14), RcmdrPlugin.epack (1.2.4), RcmdrPlugin.FactoMineR (1.01), RcmdrPlugin.TeachingDemos (1.0-5), rcom (2.2-3), Rcpp (0.8.4), RcppArmadillo (0.2.3), RCurl (1.4-2), relsurv (1.6), rEMM (1.0-0), RExcelInstaller (3.1-5), RFinanceYJ (0.1.0), RFLPtools (1.2), rgdal (0.6-27), rgenoud (5.6-7), rgl (0.91), Rhh (1.0.1), RHRV (2.4), rjags (2.1.0-5), rJava (0.8-4), rjson (0.1.9), RLRsim (2.0-5), rmetasim (1.1.12), rms (3.0-0), RNetCDF (1.2-1.1), robCompositions (1.4.2), robfilter (2.6.1), robust (0.3-11), rpartOrd...

Hi all, I have looked around for help on creating GUIs for R, but haven't found anything. I would be interested in any advice or webpages that have information on the best language, tutorials etc. for creating simple GUIs. Mainly I want to do this as a heuristic exercise. Thanks for any help. Wade Wall [[alternative HTML version deleted]]