In psudocode:<br><br>#map the files to their time.<br>filesByTimes = {}<br>for each in filesInDirectory:<br> filesByTimes[os.stat(each).st_mtime]=each<br><br>#find the largest time<br>times = filesByTimes.keys()<br>sort(times)
<br><br>#retrieve the file that goes with it<br>latestFile = filesByTimes[times[-1]]<br><br><br> --Michael<br><br><br><div><span class="gmail_quote">On 11/5/07, <b class="gmail_sendername">Fiyawerx</b> <<a href="mailto:fiyawerx@gmail.com">
fiyawerx@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I'm working on a small script that so far, using the xlrd module, (
<a href="http://www.lexicon.net/sjmachin/xlrd.html" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.lexicon.net/sjmachin/xlrd.html</a>) will parse all the files in a given directory for a xls file with a specific worksheet. This way, if the file names change, or people don't save the spreadsheet with the right name, my script will still be able to locate the correct files to use for it's data source out of multiple files / versions. So far what I have sort of goes like this :
<br><br>import os<br>import xlrd<br><br>data = {}<br><br>#path may be set externally at some point<br>data['path'] = 'mypath_to_program'<br><br>os.chdir(data['path'])<br><br>data['xls_files'] = [ file for file in
os.listdir('./') if '.xls' in file ]<br><br>first_files = [ file for file in data['xls_files'] if u'First Worksheet' in xlrd.open_workbook(file).sheet_names() ]<br>data['first_file'] = ??
<br><br>second_files = [ file for file in data['xls_files'] if u'Second Worsheet' in xlrd.open_workbook(file).sheet_names() ]<br>data['second_file'] = ??<br><br>This is where I get stuck, I'm trying to figure out how, from the files
that match, I can select the file with the most current time stamp and
use that as my main data file.<br>I know I can get the modification time with os.stat(file).st_mtime, but I'm not sure how I can sort my returns by this, to get just the most current version. Any help / thoughts would be appreciated. I'm going to be looking for other worksheets as well that might be in
other xls's, for example 'Second Worksheet' also, but I was just trying to get the 'first_files' working first. Instead of opening them each time, should I construct some type of data that stores the file, it's worksheets, and its modification times for each file found, and then just parse that list? like maybe change my xls_files around to not just be a list of names?
<br>
<br>_______________________________________________<br>Tutor maillist - <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Tutor@python.org">Tutor@python.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://mail.python.org/mailman/listinfo/tutor" target="_blank">
http://mail.python.org/mailman/listinfo/tutor</a><br><br></blockquote></div><br><br clear="all"><br>-- <br>Michael Langford<br>Phone: 404-386-0495<br>Consulting: <a href="http://www.TierOneDesign.com/">http://www.TierOneDesign.com/
</a>