Erich & Christian,
maybe there is a problem with optional arguments to methods. I will
check this with your example. In principle, passing objects as arguments
should be fine, as long as the objects are IDispatch.
Thomas
Erich Neuwirth schrieb:
I ran your code in R 2.8.0 and it worked (did not crash
but it ptobably also did not do what you wanted.
Please explain what you want.
Did you install the version of rcom compiled for R-2.8.0?
Did you run
comRegisterRegistry() after installing the new version?
Christian Asseburg wrote:
Dear Wayne, thanks, I might have to do that.
I noticed that R 2.8.0 also crashes with a command like
Chartobject$SetSourceData(Source=range, PlotBy=plotby.value)
so I suspect that the crash has something to do with passing rcom
objects as arguments to rcom functions.
With best wishes -
. . Christian
On Wed, 22 Oct 2008 16:05:36 +0200, <[EMAIL PROTECTED]> wrote:
Hi Christian,
There are some big changes to R in version R 2.8.0.
Apparently some of the dll files in the core R distribution have changed
and rcom hasnt been updated to accomodate these yet (Erich, Thomas
correct me if I am wrong).
I would revert back to R.7.2 for now.
Regards,
Wayne
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Christian
Asseburg
Sent: 22 October 2008 13:17
To: rcom-l@mailman.csd.univie.ac.at
Subject: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet
Dear RCOM list -
I've been using rcom since R version 2.5.1 to read and manipulate
workbooks in Excel. It's great to have this facility with rcom and R!
The following lines in my code worked fine with up to R 2.7.2 but in R
2.8.0 they result in a crash of R. Does anyone know why, and how to fix
this?
library(rcom)
E<-comCreateObject("Excel.Application")
W1<-E[["Workbooks"]]$Add()
S1<-E[["ActiveSheet"]]
W2<-E[["Workbooks"]]$Add()
S1$Copy(Before=W2[["Worksheets",1]])
If I just write S1$Copy() it works but I want the worksheet as a copy in
W2, not in a new workbook.
I'm using R 2.8.0 with Windows XP (Service pack 3), and rcom is installed
by downloading the package from CRAN using the R menu. My Excel
version is
Excel 2000, version 9.0.6926 SP-3.
Thanks for help. With best wishes -
. . Christian
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.8.2/1738 - Release Date: 10/21/2008 2:10 PM
_______________________________________________
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
