Try changing "sample_file.xls" to normalizePath("sample_file.xls")
so you are passing an absolute file path to Excel.Bill Dunlap TIBCO Software Inc - Spotfire Division wdunlap tibco.com > -----Original Message----- > From: r-help-boun...@r-project.org > [mailto:r-help-boun...@r-project.org] On Behalf Of Lauri Nikkinen > Sent: Thursday, July 02, 2009 10:23 AM > To: Henrique Dallazuanna > Cc: r-h...@stat.math.ethz.ch > Subject: Re: [R] read.xls: number of sheets > > Thanks, I tried and got this error: > > > setwd("C:/") > > list.files(pattern=".xls") > [1] "sample_file.xls" > > library(RDCOMClient) > > xl <- COMCreate("Excel.Application") > > xl$Workbooks()$Open("sample_file.xls")$Sheets()$Count() > Error in .COM(x, name, ...) : > 'sample_file.xls' could not be found. Check the spelling of the file > name, and verify that the file location is correct. > > If you are trying to open the file from your list of most recently > used files on the File menu, make sure that the file has not been > renamed, moved, or deleted. (Microsoft Excel) > > > > Any ideas how to proceed? > -L > > 2009/7/2 Henrique Dallazuanna <www...@gmail.com>: > > Try this: > > > > > > library(RDCOMClient) > > > > xl <- COMCreate("Excel.Application") > > xl$Workbooks()$Open("teste.xls")$Sheets()$Count() > > > > > > On Thu, Jul 2, 2009 at 11:22 AM, Lauri Nikkinen > <lauri.nikki...@iki.fi> > > wrote: > >> > >> Hi, > >> > >> I'm trying to read several Excel sheets from an Excel file into a > >> list. I'm using > >> read.xls from package 'gdata'. I would like to know how I can > >> check the number of sheets before the loop (in the example > below) so > >> that I could adjust the loop counter? Any suggestions? > >> > >> DF.list <- list() > >> for (i in 1:4) { > >> DF.list[[i]] <- read.xls("sample_file.xls", sheet=i, > >> stringsAsFactors = FALSE) > >> } > >> > >> Thanks, > >> -L > >> > >> ______________________________________________ > >> R-help@r-project.org mailing list > >> https://stat.ethz.ch/mailman/listinfo/r-help > >> PLEASE do read the posting guide > >> http://www.R-project.org/posting-guide.html > >> and provide commented, minimal, self-contained, reproducible code. > > > > > > > > -- > > Henrique Dallazuanna > > Curitiba-Paraná-Brasil > > 25° 25' 40" S 49° 16' 22" O > > > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
