[Tutor] Filtering Spreadsheet Data

John Fouhy john at fouhy.net
Mon May 23 23:01:59 CEST 2005


Luke Jordan wrote:
> 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.

pyExcelerator seems to work well for parsing Excel spreadsheets. (it 
basically gives you a dictionary for each worksheet)  Google should find 
it for you.

(you could also use COM ... but that's a bit more effort)

-- 
John.


More information about the Tutor mailing list