Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Sort CSV file within Excel based on specific column

by jaacmmason (Acolyte)
on Oct 11, 2012 at 19:57 UTC ( #998526=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    #!perl
    
    ...
     
    #Sort the file based on "Call Type" Column (F is column number 5, as A
    + is 0)     
       $Excel->sort_data('WorksheetName',5,'DESC');
    
  2. or download this
    #Find Last Column and Row
    my $LastRow = $Sheet->UsedRange->Find({What=>"*", SearchDirection=>xlP
    +revious, SearchOrder=>xlByRows})->{Row};
    my $LastCol = $Sheet->UsedRange->Find({What=>"*", SearchDirection=>xlP
    +revious, SearchOrder=>xlByColumns})->{Column};
    

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (8)
As of 2016-09-25 23:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Extraterrestrials haven't visited the Earth yet because:







    Results (473 votes). Check out past polls.