[R] 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

Re: [R] read.xls and name of worksheet

Here is a program that will get a list of the sheet names and then read in the indicated name. Modify to suit. library(rcom) xls - C:\\test.xls oxl - comCreateObject('Excel.Application') comSetProperty(oxl, Visible, TRUE) owb - comGetProperty(oxl, Workbooks) ob - comInvoke(owb, Open, xls)