Re: Importing multiple .xls files?

["Richard M. Heiberger" <rmh@temple.edu>]

## I created simple Excel files test1.xls and test3.xls in the
## directory in which my working .Data sits.
## Then I imported them in a loop.
## file.exists() allows me to go through the number sequence and lets
## the S-Plus program figure out whether there is a corresponding file.


objects(p="test[12345]")

for (i in 1:5) {
  name <- paste("test", i, sep="")
  name.i <- paste(name, ".xls", sep="")
  if (file.exists(name.i)) assign(name, importData(name.i))
}

objects(p="test[12345]")


Rich