On 01/10/2011 23:00, David Monaghan wrote:
after opening the text.xls file i need to filter all the rows in which
the status column is passed and copy the whole sheet to another sheet
I don't do this often enough to have it to mind, so what I normally do is
record a Macro, convert it to VBS and then convert that to Python.
Ouch! Slow, error prone and Windows only ;-)
Please consider using xlrd and described on http://www.python-excel.org
cheers,
Chris
--
Simplistix - Content Management, Batch Processing & Python Consulting
- http://www.simplistix.co.uk
--
http://mail.python.org/mailman/listinfo/python-list
