Displaying 2 results from an estimated 2 matches for "osheets".
Did you mean:
sheets
2009 Aug 18
2
(no subject)
...e.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, "Item", i), "Name")
>
> sheetNames <- sapply(1:n, ithSheetName)
>
> #>...
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 !=