Need A script to open a excel file and extract the data using autofilter

[Alan Meyer]

On 10/4/2011 5:12 PM, David Monaghan wrote:
> On Tue, 04 Oct 2011 19:42:06 +0100, Chris Withers<chris at 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

I've used xlrd.  It's pretty nice.

     Alan