Displaying 20 results from an estimated 21 matches for "rexcelinstaller".
2008 Apr 17
0
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...
2012 Jul 09
1
Issue with installing RExcel
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", "...
2012 May 21
16
Contactos en Madrid-ayuda con instalación
...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...
2012 Oct 27
1
help install RExcel
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...
2009 Apr 15
1
Writing .xlsx files
...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/
2010 Mar 14
1
R-Excel Macro Problem
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
2011 Apr 11
1
RExcel
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...
2008 Apr 19
7
Re ad From EXCEL
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:
2009 Jun 15
4
reading Excel file
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
2009 Feb 10
1
need help with installRExcel()
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...
2010 Aug 22
0
R Report (was RE: R-help Digest, Vol 90, Issue 25)
...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...
2011 Aug 22
0
CRAN packages maintained by you
...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...
2010 Jun 17
3
R user interface
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
2010 Jul 29
4
reading dates in Excel into R
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
2010 Jul 26
4
Fwd: Questions about templates for R
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
2010 Sep 07
5
how to you output a vector to a column in excel?
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.
2009 Jan 08
1
R and Excel
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
2010 Feb 23
5
export tables to Excel files
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
2010 Jul 18
6
CRAN (and crantastic) updates this week
...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...
2008 Oct 07
11
Creating GUIs for R
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]]