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
--
Christian Asseburg, PhD
Bayesian Statistician
IHE - Swedish Institute for Health Economics
mail: Box 2127, 22002 Lund, Sweden
email: [EMAIL PROTECTED]
tel: +4646329109
mob: +46733401477
fax: +4646121604
www: http://www.ihe.se/personal/ca_eng.htm
_______________________________________________
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
