Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

Re: Filtering an excel.

by Corion (Pope)
on Sep 02, 2012 at 11:21 UTC ( #991264=note: print w/replies, xml ) Need Help??

in reply to Filtering an excel.

See Using Win32::OLE and Excel - Tips and Tricks, and likely the list in Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks).

You don't tell us how it "doesn't seem to be working", but my guess is that there is no method named autofilter in Excel. Most methods start with an uppercase name in Excel. I would check that the name is spelled correctly, and again use the Macro Recorder approach.

Update: On thinking a bit, I realize that the (so far unmentioned) Spreadsheet::WriteExcel has a ->autofilter method. But its documentation does not mention R1C1 syntax for that method, so I guess you have to use the documeted way of passing the arguments.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://991264]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (5)
As of 2018-06-21 18:31 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (118 votes). Check out past polls.