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
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
On 10/4/2011 5:12 PM, David Monaghan wrote:
On Tue, 04 Oct 2011 19:42:06 +0100, Chris Withersch...@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
Prakash prakash...@gmail.com wrote:
Need A script to open a excel file and extract the data using
autofilter and write it in a new sheet or new file like I have to
select all rows in which all the columns contain pass as status
... try this:
http://www.python-excel.org/
Regards
Need A script to open a excel file and extract the data using
autofilter and write it in a new sheet or new file like I have to
select all rows in which all the columns contain pass as status
--
http://mail.python.org/mailman/listinfo/python-list
On Oct 1, 10:25 pm, Prakash prakash...@gmail.com wrote:
Need A script to open a excel file and extract the data using
autofilter and write it in a new sheet or new file like I have to
select all rows in which all the columns contain pass as status
from win32com.client import Dispatch
xlApp =
On Sat, 1 Oct 2011 10:35:06 -0700 (PDT), Prakash prakash...@gmail.com
wrote:
On Oct 1, 10:25 pm, Prakash prakash...@gmail.com wrote:
Need A script to open a excel file and extract the data using
autofilter and write it in a new sheet or new file like I have to
select all rows in which all the
On Sat, 01 Oct 2011 23:00:07 +0100, David Monaghan
monaghand.da...@gmail.com wrote:
from win32com.client import Dispatch
xlApp = Dispatch(Excel.Application)
xlWbook = xlApp.Workbooks.Open(rC:\Users\Administrator\Desktop\test.xls)
xlApp.Visible = 1
xlWorksheet = xlWbook.Worksheets(1)