On Tue, 04 Oct 2011 19:42:06 +0100, Chris Withers <ch...@simplistix.co.uk> wrote:
>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 All true! The reason I usually do it like that is I normally only need to do very simple things and I usually stop at the VBS stage. And I wasn't aware of xlrd - I'll give it a look. DaveM -- http://mail.python.org/mailman/listinfo/python-list
