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

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.


Comment on Re: Filtering an excel.
Select or Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://991264]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (17)
As of 2014-04-18 19:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (471 votes), past polls