> Subject: > [Tutor] Filtering Spreadsheet Data > From: > Luke Jordan <[EMAIL PROTECTED]> > Date: > Mon, 23 May 2005 15:30:33 -0500 > To: > tutor@python.org > > To: > tutor@python.org > > > Hi All, > > I have several frighteningly cumbersome reports to review at my new > job. I would like to write a python program to help me with my > analysis. The goal of the program is to filter out information that > doesn't meet certain requirements and print relevant results back to > a legible report that I can do detailed research and analysis on. The > reports come to me in Excel format. > > I have a solid understanding of basic programming. > > Any guidance/advice/starting points would be greatly appreciated. > > Thanks! > > Luke >
Excel has some nice database-like queries itself. Take a look at Advanced Filter in Help. You can essentially query a worksheet and even send the results to a different worksheet. I'd imagine that once you got the query working, you could automate it using VBA or Python. Mike _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
