Sorry, I intended to send this straight to the rcom mailing list. It's about
the rcom package.
Cheers!!
Albert-Jan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public
order, irrigation, roads, a fresh water system, and public health, what have the
Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- On Thu, 4/29/10, Albert-Jan Roskam <fomcl@yahoo.com> wrote:
From: Albert-Jan Roskam <fomcl@yahoo.com>
Subject: [R] UpdateLinks = FALSE
To: "R Mailing List" <r-help@r-project.org>
Date: Thursday, April 29, 2010, 1:07 PM
Hi,
I'm reading 100s of excel files and many of them contain links to external
files (I hate that, but that aside). Every time such a file is opened, a menu
pops up asking if I want to update the links. I never want to update the links.
I used the macro recorder to see what code would be needed to suppress that
message, but to no avail (I tried more variations, but one attempt is shown
below).
How can I suppress such messages?
excel <- comCreateObject("Excel.Application")
wb <- comGetProperty(excel, "Workbooks")
comSetProperty(wb, "UpdateLinks", FALSE)
owb <- comInvoke(wb, "Open", xlsfile) # at this point, it's too
late
Another query: the program at large erases any cells that contain formulae.
Thanks to Erich, the program now works like a charm. However, some cells contain
formulae such as "832.1 * E4 * E3" (yes I know: big, big *sigh*). I
did not take that possibility into account while writing the program. Would it
be possible to capture the number (832.1)? My first idea would be to access the
formula representation (as a string) and use a nifty regular expression.
Thank you in advance.
Cheers!!
Albert-Jan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public
order, irrigation, roads, a fresh water system, and public health, what have the
Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[[alternative HTML version deleted]]
-----Inline Attachment Follows-----
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
[[alternative HTML version deleted]]