Re: [R] Re ading multiple Excel 2007 files with a loop

9 21:38:12 > An: "Mark W.Miller" > CC: "r-help@r-project.org" > Betreff: Re: [R] Re ading multiple Excel 2007 files with a loop > > Have you looked at the read.xls() function from the gdata package? > It automates the conversion to *.csv for you. It has w

Re: [R] Re ading multiple Excel 2007 files with a loop

Thank you for all of the responses. They were all very helpful. The best response came from a gentleman at Berkeley who suggested I change the channel statement to that used below: Mark Miller Gainesville, Florida library(RODBC) setwd("U:/test folder") fname <- list.files(pattern=".\\.x

Re: [R] Re ading multiple Excel 2007 files with a loop

Have you looked at the read.xls() function from the gdata package? It automates the conversion to *.csv for you. It has worked seamlessly for me on the occasions on which I've needed to use it. cheers, Rolf Turner On 19/11/2009, at 9:09 AM, Mark W. Miller wrote: I

[R] Re ading multiple Excel 2007 files with a loop

I have several hundred Excel 2007 data files in a folder. I would like to read every file in a single given folder using a loop. I have searched the FAQ, the forum archives here, other or older R boards and the R Import / Export documentation, and have asked some very knowledgeable R users with