s-news
[Top] [All Lists]

Importing multiple .xls files?

To: s-news@lists.biostat.wustl.edu
Subject: Importing multiple .xls files?
From: 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 structure (eg. 'station*.xls' where the * is some number between 60 and 800). Is there any way in which the import.data function can be written for a batch import these files? Or can I write my own function that calls import.data and passes a file name as the parameter? I have been experimenting (quite blindly) with possible alternatives, but nothing has worked out so far. Any suggestions will be greatly appreciated.

Once again, I'm working with S-Plus 6.2 (student edition) in a Windows XP platform.

Many thanks,

Sarah


<Prev in Thread] Current Thread [Next in Thread>