RExcel's philosophy is that we extend Excel by making R functionality
available
from within Excel.
You want the opposite: you want to use R and get data from Excel or
put data into Excel.
As the email you cite says it is possible with rcom.
But everything you want to do yo way also can be done the RExcel based
way.
Possibly we will have more support for the working style you prefer,
but it really is a working style and not a matter of things not being
possible otherwise.
Look at the demo files coming with RExcel and you will see
how you can run R programs triggered by Excel.
We will definitely not support dde and the old macro language.
dde is unreliable for transferring larger amounts of data.
On Sep 10, 2008, at 3:22 PM, Schellberg, Dieter wrote:
Hi,
If you look at this,
http://article.gmane.org/gmane.comp.lang.r.rcom/171
Probably you understand.
- I definitely want to use R as front end and excel as backend.
- I already know how I can use dde to use the very old fashioned
macrofun language to open and close
Excel workbooks and do things with them very systematically. And not
spending time on syntax questions.
This approach functions nicely under e.g. SAS.
- So if anyone had an idea where the tk2dde is explained that wuld
be funny.
- If not : is anywhere a systematic explanation ( see "hopes" in
the link above)
Of RCOM in the R-Exc direction ?
Sincerly
Dieter
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
] Im Auftrag von Erich Neuwirth
Gesendet: Mittwoch, 10. September 2008 13:08
An: R (D)COM and RExcel server related issues
Betreff: Re: AW: [Rcom-l] WG: Usage of R and excel at the com layer
DDE is a VERY old technology. I would avoid it if possible.
On Sep 10, 2008, at 11:50 AM, Schellberg, Dieter wrote:
Hi,
Thanbks,
-I will try this.
- Do you know of "tcltk2" package
Which might have a "tk2dde" utility
I could not find examples of usage ...
Dieter
-----Ursprüngliche Nachricht-----
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
] Im Auftrag von Erich Neuwirth
Gesendet: Mittwoch, 10. September 2008 11:41
An: R (D)COM and RExcel server related issues
Betreff: Re: [Rcom-l] WG: Usage of R and excel at the com layer
When it comes to Excel,
I think I should answer ;-)
There are 2 technologies supporting R in Excel:
(D)COM server and R pakage rcom.
From the user's point of view the main difference is that the (D)COM
server remains totally invisible whereas when using rcom the user
also
has full access to the RGui.
I you develop things in R, it is probably better to use rcom.
The easiset way to install this is installing the packages rcom and
RExcelInst from CRAN.
Start by trying this.
On Sep 10, 2008, at 10:25 AM, Schellberg, Dieter wrote:
=> The (D)COM Server appeared in the windows startmenue .
And then tried
Library(rcom) and received:
Es gibt kein Paket rcom
excel <- comGetObject("Excel.Application")
From R console. ( version R 2.7.2)
An excel spreadsheet was already opened.
Unfortenately I received an error:
"Konnte Funtion comGetObject nicht finden".
Do you have any ideas how to cope with that situation ?
Is there an essential "step" missing between installation of DCOM
and the command from R console ?
PS: I speak german as well.
Sincerely
Dieter Schellberg
Dipl. Psych.
Dieter Schellberg
University Heidelberg
Dep. Int Medicine
INF 410
E-mail: [EMAIL PROTECTED]
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
--
Erich Neuwirth
Didactic Center for Computer Science and Institute for Scientific
Computing University of Vienna
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
--
Erich Neuwirth
Didactic Center for Computer Science and Institute for Scientific
Computing
University of Vienna
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
