The problem is that using a cell handler calls your cell handler as each cell is read. You don't really need to do that under normal circumstances, but if you do, then try something like:

#!/usr/bin/perl -w
use strict;
use warnings;
use Spreadsheet::ParseExcel;

my %CellData; # Key1=workbook, Key2=Row, Key3=column

my $parse_excel = Spreadsheet::ParseExcel->new(
        CellHandler   => \&cell_handler,
        NotSetCell    => 1
);

my $workbook = $parse_excel->Parse('file.xls');

# Now that we've parsed the sheet, we can access any data we like,
# So let's print cell C1 on sheet "FOO"
print $CellData{FOO}{C}{1}, "\n";

sub cell_handler {
    # Cell information passed to us
    my ($WB, $IDX, $R, $C, $Cell) = @_;

    # Build our hash keys
    my $SheetName = $WB->worksheet($IDX)->get_name();
    my $ColName = numToColumnName($C);
    my $RowName = $R;
    $CellData{$SheetName}{$ColName}{$RowName} = $Cell->{_Value};
}

sub numToColumnName {
    my $C = shift;
    my $colName = '';
    if ($C>25) {
        $colName = substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $C/26, 1);
        $C = $C % 26;
    }
    $colName .= substr('ABCDEFGHIJKLMNOPQRSTUVWXYZ', $C, 1);
}

[download]

(Note: Untested!)

Of course, if you don't need to use a cell handler, you can just use the example in the first page of the documentation to access the data by sheet / row / column...

...roboticus

In reply to Re: Accessing values in a XSL file. by roboticus
in thread Accessing values in a XSL file. by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.