[Tutor] Filtering Spreadsheet Data

[Mike Hansen]

> Subject:
> [Tutor] Filtering Spreadsheet Data
> From:
> Luke Jordan <luke.jordan at gmail.com>
> Date:
> Mon, 23 May 2005 15:30:33 -0500
> To:
> tutor at python.org
> 
> To:
> tutor at 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