Displaying 2 results from an estimated 2 matches for "ithsheetname".
2009 Aug 18
2
(no subject)
...(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)
>
> #> sheetNames
> # [1] "Platten gesamt" "Platte 1-5" "Platte 6-10" "...
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 !=