Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Importing\s+multiple\s+\.xls\s+files\?\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Importing\s+multiple\s+\.xls\s+files\?\s*$/: 4 ]

Total 4 documents matching your query.

1. Importing multiple .xls files? (score: 1): Author: Sarah Henderson <sarah.henderson@ubc.ca>; Date: Sat, 16 Jul 2005 18:30:00 -0800; Hello to all and, once again, my apologies for what is probably a very novice question. I have a folder full of 300 .xls files that I need to import into S-Plus. All files have the same name structur; /archives/html/s-news/2005-07/msg00098.html (7,636 bytes)
2. Re: Importing multiple .xls files? (score: 1): Author: Spencer Graves <spencer.graves@pdf.com>; Date: Sat, 16 Jul 2005 19:36:42 -0700; 1. Produce vectors of character strings with the names of the *.xls files and of the target data.frames you want to create. For example, the following will "station60", "station61", ..., "station800"; /archives/html/s-news/2005-07/msg00099.html (10,793 bytes)
3. Re: Importing multiple .xls files? (score: 1): Author: "Richard M. Heiberger" <rmh@temple.edu>; Date: Sat, 16 Jul 2005 22:56:31 -0400; 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]"); /archives/html/s-news/2005-07/msg00100.html (7,297 bytes)
4. Re: Importing multiple .xls files? (score: 1): Author: Sarah Henderson <sarah.henderson@ubc.ca>; Date: Sat, 16 Jul 2005 22:45:47 -0800; Thanks to all who replied! The problem has been solved and I can see how the responses are going to be very valuable in my future work with these data. A summary is found below: _____________________; /archives/html/s-news/2005-07/msg00101.html (10,961 bytes)

Current List: 1 - 4
Page: [1]