Another remark:
If you just want to read and write xls files AND are working on windows,
there is the package xlsReadWrite which allows you to do just that.
You can use it even on machines without Excel.
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
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.169 / Virus Database: 270.6.19/1663 - Release Date: 9/9/2008 7:04 PM
--
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
_______________________________________________
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
