Chris Withers chris at simplistix.co.uk
Tue Oct 4 14:42:06 EDT 2011

• Previous message (by thread): Need A script to open a excel file and extract the data using autofilter
• Next message (by thread): Need A script to open a excel file and extract the data using autofilter
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

---

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

---

• Previous message (by thread): Need A script to open a excel file and extract the data using autofilter
• Next message (by thread): Need A script to open a excel file and extract the data using autofilter
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

---

More information about the Python-list mailing list