| Subject: | XLS2CSV Bug 93327 |
| Date: | Fri, 2 Dec 2016 20:52:18 +0000 (UTC) |
| To: | <bug-xls2csv [...] rt.cpan.org> |
| From: | Larry Baker <lbakersd [...] yahoo.com> |
Hello,
I have the same issue as bug reported #93327 XLS2CSV.
Looks like this has been open for 3 years. I'm curious to know if this will be looked into or what the steps are to getting this in a queue for review?
OS:
This is perl 5, version 22, subversion 2 (v5.22.2) built for cygwin-thread-multi
COMMAND:
xls2csv.pl -x CONVERT_0443_20160224110405.xlsx -c CONVERT_0443_20160224110405.csv
ERROR:
Can't use an undefined value as an ARRAY reference at /opt/tools/cbin/xls2csv.pl line 144.
CODE: please find ***HERE*** this is line 144.
my $Sheet;
if ($O{'w'})
{
$Sheet = $Book->Worksheet($O{'w'});
die "Invalid worksheet\n" if !defined $Sheet;
unless ($O{'q'})
{
print qq|Converting the "$Sheet->{Name}" worksheet.\n|;
}
}
elsif ($O{'n'})
{
my $sheet_number = $O{'n'} - 1;
$Sheet = $Book->{Worksheet}->[$sheet_number];
die "Invalid worksheet\n" if !defined $Sheet;
}
else
{
($Sheet) = @{$Book->{Worksheet}};
****HERE**** if (!$O{'q'} && $Book->{SheetCount}>1)
{
print qq|Multiple worksheets found. Will convert the "$Sheet->{Name}" worksheet.\n|;
}
}
Thanks!
Larry