in reply to Read entire row and/or sheet with Spreadsheet::Read

The POD for Spreadsheet::Read mentions a "debug" option:
Enable some diagnostic messages to STDERR. The value determines how much diagnostics are dumped (using Data::Dumper). A value of 9 and higher will dump the entire structure from the back-end parser. 
use Spreadsheet::Read qw(row rows);
my $ref2 = ReadData ("test.xls", debug => 9);

[download]

In Section Seekers of Perl Wisdom