Displaying 7 results from an estimated 7 matches for "comgetproperty".
2007 Dec 14
4
rcom close Excel problem
...x$Exit()
and Excel refuses to die.
Thank you very much.
S.
"You can't kill me, I will not die" Mojo Nixon
I also have a problem with saving. It produces a pop-up dialog and
does
not take my second parameter:
x<-comCreateObject("Excel.Application")
wb<-comInvoke(comGetProperty(x,"Workbooks"),"Open","G:
/MR/Stephen/repo.
xls", "0")
sh<-comGetProperty(wb,"Worksheets","Market Data")
range1 <- comGetProperty(sh,"Range","C10","I11")
vals <- comGetProperty(range1,"Value"...
2006 Jun 29
1
RCOM Package
...out this package with good examples? I've read
the Package description... but there are not really good
descriptions/examples.
I know the following parameters/commands:
#Connect to the active Workbook
excel <- comGetObject("Excel.Application")
#Set the active sheet
sheet <- comGetProperty(excel,"ActiveSheet")
#Set a specific sheet
sheet <- comGetProperty(excel,"Worksheets","WorksheetXY")
#Create a new Worksheet
comInvoke(comGetProperty(excel,"Worksheets"),"Add")
#Define a range in a defined sheet
range1 <- comGetProperty(she...
2009 Aug 18
2
(no subject)
...>
> xls <- "Platten_Liste_090421.xls"
>
> xlsfile <- file.path(path,xls)
>
> file.exists(xlsfile)
[1] TRUE
>
>
>
> oxl <- comCreateObject("Excel.Application")
>
> comSetProperty(oxl, "Visible", TRUE)
NULL
>
> owb <- comGetProperty(oxl, "Workbooks")
>
> ob <- comInvoke(owb, "Open", xlsfile)
>
> osheets <- comGetProperty(ob, "Worksheets")
>
> n <- comGetProperty(osheets, "Count")
>
> ithSheetName <- function(i) comGetProperty(comGetProperty(osheets, &q...
2010 Oct 01
0
Populating values in a PowerPoint table
...tation and the table:
require(R2PPT)
# initialize the presentation
myPres<-PPT.Init(visible=TRUE)
# create title slide
myPres<-PPT.AddTitleSlide(myPres,title="Fancy Title",subtitle="Fancy SubTitle")
# create and select a table slide
myPres$Current.Slide <- comInvoke(comGetProperty(myPres$pres,
"Slides"),"Add", comGetProperty(comGetProperty(myPres$pres, "Slides"),
"Count") + 1, 4)
comInvoke(myPres$Current.Slide, "Select")
# populate the slide's title
slideTitleHanlde <-
comGetProperty(comGetProperty(comGetProperty(comG...
2009 Sep 15
0
chinese character support issue of rcom
...always get the part of the Chinese character.
Any suggestion would be appreciated.
Thanks.
Michael
> library(rcom)
Loading required package: rscproxy
> txe<-comCreateObject("Excel.Application")
> comSetProperty(txe,"Visible",TRUE);
NULL
> newwb <- comInvoke(comGetProperty(txe,"Workbooks"),"Add")
> ws <- comGetProperty(newwb,"Worksheets",1)
> e<-comGetProperty(ws,"Range","A1")
> comSetProperty(e,"Value","abc defg hijl agfasdg")
NULL
> comGetProperty(e,"Value")
[1] "...
2009 Mar 12
1
read.xls and name of worksheet
Hi,
I would like to some excel files with some worksheets. I tried this with
the following R script:
library(gdata)
i<-1
rc<-0
while(rc != "try-error") {
wksh<-try(read.xls("cluster-microarray-FW.xls",sheet=i,verbose=TRUE,perl="perl"))
rc<-class(wksh)
print(sprintf("------- i=%2d rc=%s ---------------",i,rc))
if (rc !=
2010 Apr 29
1
UpdateLinks = FALSE
.... 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. Ho...