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
