in reply to Spreadsheet:Parse Excel problem

I don't deal with excel much, but the error message itself is pretty simple, and is explained rather clearly in perldiag...

You tried to reference a substr() that pointed outside of a string. That is, the absolute value of the offset was larger than the length of the string.

So basically you get this message as a warning if you try to do something like:

my $string = "foobar";
my $letter = substr( $string, 42, 1 );

[download]

It's also a fatal error if you try and do that while using substr as an lvalue (as in my $x = substr( $string, 42, 1 );).

www.jasonkohles.com
We're not surrounded, we're in a target-rich environment!

Replies are listed 'Best First'.
Re^2: Spreadsheet:Parse Excel problem
by Not_a_Number (Prior) on Apr 13, 2008 at 18:57 UTC
    ...the error message itself is pretty simple

    Indeed it is. But I'm not sure how this observation helps the OP. Lines 1848-1850 of SpreadSheet::ParseExcel are:

    for(my $i = ($iDiff/2); $i>=1;$i--) {
  substr($sWk, $i+1, 0) =  "\x00";
}

    [download]

    Looks like a bug in the module to me, unless svar is doing something very strange when using it.

[reply]
[d/l]

In Section Seekers of Perl Wisdom