On Fri, 24 Feb 2012 10:54:15 -0500, "John Ribeiro via RT"
<bug-Spreadsheet-Read@rt.cpan.org> wrote:
Show quoted text> Dear Sir or Madam,
Sir
Show quoted text> Thanks for responding so quickly to my recent bug report.
You're welcome
Show quoted text> I have another related issue. I'd like to be able to report that a
> given sheet is blank using the label. Unfortunately, if a sheet is
> empty, the label data element is undefined.
This all is inherent to the value of the "clip" attribute, which
defaults to the truthness of the "cells" attribute, which is true by
default.
--8<--- From the docs
If set, C<ReadData ()> will remove all trailing lines and columns per
sheet that have no visual data.
This option is only valid if C<cells> is true. The default value is
true if C<cells> is true, and false otherwise.
-->8---
If you want empty sheets to return as valid sheets including all rows
and columns with possible empty data, you will have to set "clip" to a
false value
my $ss = ReadData ("file.xls", clip => 0);
Show quoted text> Therefore I am unable to report with certainty, which individual
> sheets are empty.
If a sheet is completely empty, it is skipped when "clip" is true.
That might be worth an extra note in the documentation.
--
H.Merijn Brand
http://tux.nl Perl Monger
http://amsterdam.pm.org/
using perl5.00307 .. 5.14 porting perl5 on HP-UX, AIX, and openSUSE
http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/
http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/