title: Need more examples on how to use Spreadsheet::ParseExcel
body: <p>I have been using the <a href="http://search.cpan.org/dist/Spreadsheet-ParseExcel/" rel="nofollow noreferrer">Spreadsheet::ParseExcel</a> to list the contents of spreadsheet. I've seen several examples on how to dump the entire spreadsheet.   I really would like to see how to use this script more selectively.  </p>
  
  <p>The example below from IBM basically dumps the content of all cells that have data. </p>
  
  <pre><code>#!/usr/bin/perl -w
  
  use strict;
  use Spreadsheet::ParseExcel;
  
  my $oExcel = new Spreadsheet::ParseExcel;
  
  die "You must provide a filename to $0 to be parsed as an Excel file" unless @ARGV;
  
  my $oBook = $oExcel-&gt;Parse($ARGV[0]);
  my($iR, $iC, $oWkS, $oWkC);
  print "FILE  :", $oBook-&gt;{File} , "\n";
  print "COUNT :", $oBook-&gt;{SheetCount} , "\n";
  
  print "AUTHOR:", $oBook-&gt;{Author} , "\n"
   if defined $oBook-&gt;{Author};
  
  for(my $iSheet=0; $iSheet &lt; $oBook-&gt;{SheetCount} ; $iSheet++)
  {
   $oWkS = $oBook-&gt;{Worksheet}[$iSheet];
   print "--------- SHEET:", $oWkS-&gt;{Name}, "\n";
   for(my $iR = $oWkS-&gt;{MinRow} ;
       defined $oWkS-&gt;{MaxRow} &amp;&amp; $iR &lt;= $oWkS-&gt;{MaxRow} ;
       $iR++)
   {
    for(my $iC = $oWkS-&gt;{MinCol} ;
        defined $oWkS-&gt;{MaxCol} &amp;&amp; $iC &lt;= $oWkS-&gt;{MaxCol} ;
        $iC++)
    {
     $oWkC = $oWkS-&gt;{Cells}[$iR][$iC];
     print "( $iR , $iC ) =&gt;", $oWkC-&gt;Value, "\n" if($oWkC);
    }
   }
  }
  </code></pre>
  
  <p>Can someone give me an example of how I can specify some action to take for a certain column for every row?</p>
  
  <p>For example, I have a spreadsheet with 7 columns and n rows.  I want to reformat the data in each of the columns in a certain way. Perhaps I want take column 6 for every row and append some text to the end of the string stored in the cell.  How would that be set up?</p>