Displaying 6 results from an estimated 6 matches for "comsetproperty".
Did you mean:
comgetproperty
2009 Sep 15
0
chinese character support issue of rcom
...s that there is some problem of
Chinese character supporting.
comGetPropery() 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 def...
2006 Jun 29
1
RCOM Package
...rty(excel,"Worksheets"),"Add")
#Define a range in a defined sheet
range1 <- comGetProperty(sheet,"Range","A1","A20")
#Read out this range from Excel
val1 <- as.double(comGetProperty(range1,"Value"))
#Give back the results to Excel
comSetProperty(range1,"Value",val1)
Some of my questions are:
- How can I rename a worksheet?
- How can I define the name of a new worksheet?
- How can I delete a worksheet?
- How can I connect to a specific Workbook, if more than one is opened?
- ...
Can someone help me?
Thanks,
Thomas
2010 Apr 29
1
UpdateLinks = FALSE
...e 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 &q...
2009 Aug 18
2
(no subject)
...> path<-"I:/subProjects/bh/HPGD/"
>
> setwd(path)
>
> 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")
>
>...
2010 Oct 01
0
Populating values in a PowerPoint table
...Count") + 1, 4)
comInvoke(myPres$Current.Slide, "Select")
# populate the slide's title
slideTitleHanlde <-
comGetProperty(comGetProperty(comGetProperty(comGetProperty(myPres$Current.Slide,
"Shapes"), "Title"), "TextFrame"), "TextRange")
comSetProperty(slideTitleHanlde, "Text", "Table Slide Title")
# Add table to current slide
myShapes <- comGetProperty(myPres$Current.Slide, "Shapes")
myTable1 <- comInvoke(myShapes, "AddTable",7,3)
--
Saar Golde, Ph.D. <saar at revolutionanalytics.com>
Analy...
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 !=