[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