Bug #33248 for xls2csv: xls empty cell bug

Subject:	xls empty cell bug
Date:	Thu, 14 Feb 2008 09:14:52 +0100
To:	bug-xls2csv [...] rt.cpan.org
From:	Gász Zoltán <zoltang [...] playout.hu>

Hello! I found the following bug: I excute the following command on a system with openSuse10.2, perl 5.8.8-32 : xls2csv -x test.XLS -b iso-8859-2 -c test.csv bug: The rows, where test.xls has empty cell in the first column, will be not exported to test.csv I really like your script, I want to use it for automated batch conversion. Thank You! Zoltán Gász Luminis Ltd., Hungary Show quoted text

___________________________________ My system (uname -a): Linux <host> 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006 i686 i686 i386 GNU/Linux My perl packages (rpm -qa | grep perl): perl-Digest-SHA1-2.11-20 limal-perl-1.2.9-5 perl-Digest-HMAC-1.01-525 perl-Bootloader-0.4.5-3 yast2-perl-bindings-2.14.0-9 perl-Net-ext-1.011-34 perl-libxml-perl-0.08-31 perl-Prima-1.21-4 perl-Sys-Hostname-Long-1.4-20 perl-XML-RegExp-0.03-509 perl-HTML-Clean-0.8-706 perl-Class-Date-1.1.9-20 perl-Carp-Assert-0.18-33 perl-Params-Validate-0.86-14 perl-BerkeleyDB-0.31-12 perl-Apache-SessionX-2.01-34 perl-SQL-Statement-1.15-10 perl-ExtUtils-F77-1.15-31 perl-Time-modules-2006.0814-17 perl-Regexp-Shellish-0.93-34 perl-PDF-API2-0.55-12 perl-Text-Iconv-1.4-32 perl-spamassassin-3.1.6-15 perl-IO-Tty-1.07-16 perl-DBD-CSV-0.22-32 perl-Mcrypt-2.4.8.2-499 perl-FastCGI-2.4.0-33 perl-XML-XQL-0.68-171 perl-Text-Kakasi-2.04-31 perl-Net-Jabber-2.0-36 perl-5.8.8-32 perl-Compress-Zlib-1.42-20 perl-XML-Writer-0.601-17 sax2-libsax-perl-8.1-83.2 perl-Carp-Clan-5.7-14 perl-Convert-BER-1.3101-224 perl-IO-String-1.08-30 perl-Cyrus-IMAP-2.2.13-24 perl-Crypt-DES-2.05-30 perl-HTTP-DAV-0.31-76 perl-HTML-Tree-3.21-20 perl-Set-Object-1.18-16 perl-Class-MethodMaker-2.08-30 perl-Glib-1.140-17 perl-PerlIO-eol-0.13-34 perl-GD-2.35-18 perl-Archive-Zip-1.16-31 perl-SVN-Simple-0.27-39 perl-Algorithm-Diff-1.1902-20 perl-Encode-HanExtra-0.10-31 perl-MLDBM-2.01-280 perl-Log-Log4perl-1.07-8 perl-Text-CSV_XS-0.23-390 perl-Data-Hierarchy-0.31-17 perl-Test-Base-0.52-8 perl-Chart-2.4.1-33 perl-Apache-AuthNetLDAP-0.29-38 perl-XML-DOM-1.44-33 perl-ldap-ssl-0.33-34 perl-Mail-Mbox-MessageParser-1.4005-17 perl-SOAP-Lite-0.69-10 perl-OLE-Storage_Lite-0.14-11.1.opensuse10.2.rf perlref-5.004.1-213 perl-TimeDate-1.16-154 perl-Net-Daemon-0.39-8 perl-TermReadKey-2.30-31 perl-Tie-IxHash-1.21-618 perl-Parse-RecDescent-1.80-277 perl-Crypt-SSLeay-0.51-147 perl-HTML-Parser-3.55-20 perl-PlRPC-0.2018-31 perl-X500-DN-0.28-151 perl-Net-DNS-0.59-16 perl-DBD-SQLite-1.13-19 perl-Config-IniFiles-2.39-31 perl-Date-Calc-5.4-32 perl-Convert-UUlib-1.051-31 perl-DBD-ODBC-1.06-264 perl-IO-Multiplex-1.08-14 perl-libapt-pkg-0.1.13-36 perl-ldap-0.33-34 perl-IO-Digest-0.10-34 perl-Pod-Simple-3.04-30 perl-Pod-Escapes-1.04-34 perl-Net-IPv4Addr-0.10-35 perl-Config-General-2.31-30 perl-HTML-Template-2.8-30 perl-Class-XPath-1.4-30 perl-Class-Spiffy-0.15-8 subversion-perl-1.4.0-29 perl-GraphicsMagick-1.1.7-24 perl-GDTextUtil-0.85-160 perl-Net-CIDR-Lite-0.18-30 perl-PerlIO-via-dynamic-0.12-17 perl-CGI-Application-4.06-8 perl-BSD-Resource-1.28-21 perl-BIND-Conf_Parser-0.97-385 perl-Authen-SASL-2.10-20 perl-Apache-Filter-1.024-34 perl-MailTools-1.74-20 perl-XML-NamespaceSupport-1.09-31 perl-File-MMagic-1.22-33 perl-ExtUtils-Depends-0.205-31 perl-Time-Period-1.20-335 perl-MIME-Types-1.17-17 perl-SNMP-5.4.rc2-4 perl-DateManip-5.44-30 perl-Locale-Maketext-Simple-0.18-17 perl-Image-Size-3.01-17 perl-IPC-Run-0.80-20 perl-Test-Pod-1.26-17 perl-Unicode-String-2.09-30 perl-Data-UUID-0.145-16 perl-Unicode-Map8-0.12-180 perl-ptkdb-1.1091-15 perl-Template-Toolkit-2.15-21 perl-Pod-Coverage-0.18-8 perl-HTML-Format-2.04-33 perl-Cairo-1.01-16 perl-Authen-SASL-Cyrus-0.12-36 perl-SVN-Mirror-0.70-23 perl-PDL-2.4.3-25 perl-MIME-tools-5.420-20 perl-Inline-C-0.12-237 perl-Xmms-0.12-410 perl-HTTPS-Daemon-1.02-38 perl-XML-LibXML-1.61-15 perl-Text-ChaSen-2.3.3-129 perl-XML-LibXSLT-1.59-20 perl-OpenCA-CRL-0.9.17-93 perl-Unicode-Map-0.112-5.1.opensuse10.2.rf perl-Net-IP-1.23-32 perl-IO-Zlib-1.04-32 perl-Digest-MD4-1.5-31 perl-File-Tail-0.99.3-30 perl-HTML-Tagset-3.10-30 perl-XML-Parser-2.34-61 perl-Crypt-SmbHash-0.12-31 perl-libwww-perl-5.805-32 perl-DBI-1.52-17 perl-DBD-mysql-3.0008-12 perl-Bit-Vector-6.4-31 apache2-mod_perl-2.0.2-38 perl-Convert-TNEF-0.17-292 perl-libintl-perl-1.16-2.3 perl-Net-Telnet-3.03-213 perl-libconfigfile-1.1.1-31 perl-Curses-1.14-20 perl-PostScript-Simple-0.07-30 perl-Net-Netmask-1.9014-12 perl-Spreadsheet-WriteExcel-2.17-20 perl-Spiffy-0.30-8 perl-XML-Simple-2.15-14 perl-HTML-SimpleParse-0.12-152 perl-HTML-FillInForm-1.06-30 perl-Class-WhiteHole-0.04-97 perl-Class-Data-Inheritable-0.06-16 perl-PerlMagick-6.3.0.0-16 perl-Tk-804.027-31 perl-NKF-2.0.5-31 perl-PerlIO-via-symlink-0.05-31 perl-Module-Info-0.30-30 perl-FreezeThaw-0.43-34 perl-Filter-1.32-30 perl-Archive-Tar-1.30-17 perl-Apache-Session-1.81-23 perl-Set-Crontab-1.00-462 perl-XML-NodeFilter-0.01-36 perl-ExtUtils-PkgConfig-1.07-31 perl-Encode-JIS2K-0.02-32 perl-MP3-Info-1.13-31 perl-Regexp-Common-2.120-32 perl-MIME-Lite-3.01-173 perl-Devel-CoreStack-1.3-89 perl-DBD-XBase-0.241-59 perl-Locale-Maketext-Lexicon-0.62-17 perl-PDA-Pilot-0.12.1-27 perl-IO-stringy-2.110-31 perl-NetAddr-IP-3.32-20 perl-Test-Pod-Coverage-1.08-8 perl-Unix-Syslog-0.100-59 perl-IO-Stty-.02-550 perl-IO-Socket-SSL-1.01-19 perl-Net-Server-0.94-18 perl-Crypt-CBC-2.19-17 perl-XML-SAX-0.12-35 perl-Class-Accessor-0.27-20 perl-Module-Build-0.2805-8 perl-Arch-0.5.1-34 perl-FileHandle-Unget-0.1621-30 perl-Mail-SPF-Query-1.999.1-20 perl-Quantum-Superpositions-2.02-153 perl-Qt-3.008-180 perl-XML-XSLT-0.48-59 perl-Gtk2-1.140-24 perl-XML-Generator-0.99-34 perl-Net-XMPP-1.0-35 perl-OpenCA-X509-0.9.47-104 perl-Wx-0.59-14 perl-gettext-1.05-31 perl-Cyrus-SIEVE-managesieve-2.2.13-24 limal-ca-mgm-perl-1.2.9-4 perl-Convert-ASN1-0.20-20 perl-IO-Socket-INET6-2.51-31 perl-CursesWidgets-1.997-34 perl-Crypt-Blowfish-2.10-31 perl-Socket6-0.18-31 perl-Set-Scalar-1.20-30 perl-Class-Multimethods-1.70-465 perl-Getopt-Mixed-1.008-217 perl-CDDB_get-2.27-30 perl-GDGraph-1.43-43 perl-AppConfig-1.63-17 perl-Apache-AuthCookie-3.10-10 perl-Algorithm-Annotate-0.10-34 perl-XML-LibXML-Common-0.13-35 perl-Devel-Symdump-2.0604-12 perl-RPC-XML-0.59-21 perl-Net_SSLeay-1.30-32 perl-NetxAP-0.02-588 perl-razor-agents-2.77-30 perl-Pod-HtmlPsPdf-0.04-381 perl-Class-Inspector-1.16-8 perl-Apache2-AuthCookieDBI-2.03-8 perl-MLDBM-Sync-0.30-276 perl-Module-Pluggable-3.1-8 perl-Alien-wxWidgets-0.22-14 perl-Spreadsheet-ParseExcel-0.31-5.1.opensuse10.2.rf perl-Data-ShowTable-3.3-602 perl-URI-1.35-33 perl-Config-Crontab-1.20-10 perl-DBD-Pg-1.49-22 perl-TermReadLine-Gnu-1.15-32 perl-bp-0.7-36 perl-YAML-0.62-8 perl-Net-IRC-0.75-10 perl-HTML-Template-JIT-0.05-30 perl-Clone-0.22-12 perl-Class-Autouse-1.18-32 perl-Calendar-Simple-1.17-8 perl-Parse-Yapp-1.05-421 perl-Font-AFM-1.19-79 perl-Apache-DBI-1.03-20 perl-File-Type-0.22-34 perl-ExtUtils-ParseXS-2.16-8 perl-Time-Duration-1.04-20 perl-SGMLS-1.03ii-415 perl-Tie-Cache-0.17-274 perl-Inline-0.44-224 perl-Text-DelimMatch-1.06-75 perl-WeakRef-0.01-14 perl-Net-SNMP-5.2.0-30 perl-HTML-Template-Expr-0.07-20 perl-GD-Graph3d-0.63-42 perl-Expect-1.20-16 perl-Log-Dispatch-2.13-8 perl-XML-Stream-1.22-34 perl-OpenCA-OpenSSL-0.9.91-105 perl-OpenCA-REQ-0.9.52-93

On Thu Feb 14 03:15:47 2008, zoltang@playout.hu wrote: Show quoted text

> Hello! > > I found the following bug: > I excute the following command on a system with openSuse10.2, perl > 5.8.8-32 : > > xls2csv -x test.XLS -b iso-8859-2 -c test.csv > > bug: > The rows, where test.xls has empty cell in the first column, will be

not Show quoted text

> exported to test.csv > > I really like your script, I want to use it for automated batch

conversion. Show quoted text

> > Thank You! > > Zoltán Gász > Luminis Ltd., Hungary > > > ___________________________________ > > My system (uname -a): > Linux <host> 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006 > i686 i686 i386 GNU/Linux > > My perl packages (rpm -qa | grep perl): > > perl-Digest-SHA1-2.11-20 > limal-perl-1.2.9-5 > perl-Digest-HMAC-1.01-525 > perl-Bootloader-0.4.5-3 > yast2-perl-bindings-2.14.0-9 > perl-Net-ext-1.011-34 > perl-libxml-perl-0.08-31 > perl-Prima-1.21-4 > perl-Sys-Hostname-Long-1.4-20 > perl-XML-RegExp-0.03-509 > perl-HTML-Clean-0.8-706 > perl-Class-Date-1.1.9-20 > perl-Carp-Assert-0.18-33 > perl-Params-Validate-0.86-14 > perl-BerkeleyDB-0.31-12 > perl-Apache-SessionX-2.01-34 > perl-SQL-Statement-1.15-10 > perl-ExtUtils-F77-1.15-31 > perl-Time-modules-2006.0814-17 > perl-Regexp-Shellish-0.93-34 > perl-PDF-API2-0.55-12 > perl-Text-Iconv-1.4-32 > perl-spamassassin-3.1.6-15 > perl-IO-Tty-1.07-16 > perl-DBD-CSV-0.22-32 > perl-Mcrypt-2.4.8.2-499 > perl-FastCGI-2.4.0-33 > perl-XML-XQL-0.68-171 > perl-Text-Kakasi-2.04-31 > perl-Net-Jabber-2.0-36 > perl-5.8.8-32 > perl-Compress-Zlib-1.42-20 > perl-XML-Writer-0.601-17 > sax2-libsax-perl-8.1-83.2 > perl-Carp-Clan-5.7-14 > perl-Convert-BER-1.3101-224 > perl-IO-String-1.08-30 > perl-Cyrus-IMAP-2.2.13-24 > perl-Crypt-DES-2.05-30 > perl-HTTP-DAV-0.31-76 > perl-HTML-Tree-3.21-20 > perl-Set-Object-1.18-16 > perl-Class-MethodMaker-2.08-30 > perl-Glib-1.140-17 > perl-PerlIO-eol-0.13-34 > perl-GD-2.35-18 > perl-Archive-Zip-1.16-31 > perl-SVN-Simple-0.27-39 > perl-Algorithm-Diff-1.1902-20 > perl-Encode-HanExtra-0.10-31 > perl-MLDBM-2.01-280 > perl-Log-Log4perl-1.07-8 > perl-Text-CSV_XS-0.23-390 > perl-Data-Hierarchy-0.31-17 > perl-Test-Base-0.52-8 > perl-Chart-2.4.1-33 > perl-Apache-AuthNetLDAP-0.29-38 > perl-XML-DOM-1.44-33 > perl-ldap-ssl-0.33-34 > perl-Mail-Mbox-MessageParser-1.4005-17 > perl-SOAP-Lite-0.69-10 > perl-OLE-Storage_Lite-0.14-11.1.opensuse10.2.rf > perlref-5.004.1-213 > perl-TimeDate-1.16-154 > perl-Net-Daemon-0.39-8 > perl-TermReadKey-2.30-31 > perl-Tie-IxHash-1.21-618 > perl-Parse-RecDescent-1.80-277 > perl-Crypt-SSLeay-0.51-147 > perl-HTML-Parser-3.55-20 > perl-PlRPC-0.2018-31 > perl-X500-DN-0.28-151 > perl-Net-DNS-0.59-16 > perl-DBD-SQLite-1.13-19 > perl-Config-IniFiles-2.39-31 > perl-Date-Calc-5.4-32 > perl-Convert-UUlib-1.051-31 > perl-DBD-ODBC-1.06-264 > perl-IO-Multiplex-1.08-14 > perl-libapt-pkg-0.1.13-36 > perl-ldap-0.33-34 > perl-IO-Digest-0.10-34 > perl-Pod-Simple-3.04-30 > perl-Pod-Escapes-1.04-34 > perl-Net-IPv4Addr-0.10-35 > perl-Config-General-2.31-30 > perl-HTML-Template-2.8-30 > perl-Class-XPath-1.4-30 > perl-Class-Spiffy-0.15-8 > subversion-perl-1.4.0-29 > perl-GraphicsMagick-1.1.7-24 > perl-GDTextUtil-0.85-160 > perl-Net-CIDR-Lite-0.18-30 > perl-PerlIO-via-dynamic-0.12-17 > perl-CGI-Application-4.06-8 > perl-BSD-Resource-1.28-21 > perl-BIND-Conf_Parser-0.97-385 > perl-Authen-SASL-2.10-20 > perl-Apache-Filter-1.024-34 > perl-MailTools-1.74-20 > perl-XML-NamespaceSupport-1.09-31 > perl-File-MMagic-1.22-33 > perl-ExtUtils-Depends-0.205-31 > perl-Time-Period-1.20-335 > perl-MIME-Types-1.17-17 > perl-SNMP-5.4.rc2-4 > perl-DateManip-5.44-30 > perl-Locale-Maketext-Simple-0.18-17 > perl-Image-Size-3.01-17 > perl-IPC-Run-0.80-20 > perl-Test-Pod-1.26-17 > perl-Unicode-String-2.09-30 > perl-Data-UUID-0.145-16 > perl-Unicode-Map8-0.12-180 > perl-ptkdb-1.1091-15 > perl-Template-Toolkit-2.15-21 > perl-Pod-Coverage-0.18-8 > perl-HTML-Format-2.04-33 > perl-Cairo-1.01-16 > perl-Authen-SASL-Cyrus-0.12-36 > perl-SVN-Mirror-0.70-23 > perl-PDL-2.4.3-25 > perl-MIME-tools-5.420-20 > perl-Inline-C-0.12-237 > perl-Xmms-0.12-410 > perl-HTTPS-Daemon-1.02-38 > perl-XML-LibXML-1.61-15 > perl-Text-ChaSen-2.3.3-129 > perl-XML-LibXSLT-1.59-20 > perl-OpenCA-CRL-0.9.17-93 > perl-Unicode-Map-0.112-5.1.opensuse10.2.rf > perl-Net-IP-1.23-32 > perl-IO-Zlib-1.04-32 > perl-Digest-MD4-1.5-31 > perl-File-Tail-0.99.3-30 > perl-HTML-Tagset-3.10-30 > perl-XML-Parser-2.34-61 > perl-Crypt-SmbHash-0.12-31 > perl-libwww-perl-5.805-32 > perl-DBI-1.52-17 > perl-DBD-mysql-3.0008-12 > perl-Bit-Vector-6.4-31 > apache2-mod_perl-2.0.2-38 > perl-Convert-TNEF-0.17-292 > perl-libintl-perl-1.16-2.3 > perl-Net-Telnet-3.03-213 > perl-libconfigfile-1.1.1-31 > perl-Curses-1.14-20 > perl-PostScript-Simple-0.07-30 > perl-Net-Netmask-1.9014-12 > perl-Spreadsheet-WriteExcel-2.17-20 > perl-Spiffy-0.30-8 > perl-XML-Simple-2.15-14 > perl-HTML-SimpleParse-0.12-152 > perl-HTML-FillInForm-1.06-30 > perl-Class-WhiteHole-0.04-97 > perl-Class-Data-Inheritable-0.06-16 > perl-PerlMagick-6.3.0.0-16 > perl-Tk-804.027-31 > perl-NKF-2.0.5-31 > perl-PerlIO-via-symlink-0.05-31 > perl-Module-Info-0.30-30 > perl-FreezeThaw-0.43-34 > perl-Filter-1.32-30 > perl-Archive-Tar-1.30-17 > perl-Apache-Session-1.81-23 > perl-Set-Crontab-1.00-462 > perl-XML-NodeFilter-0.01-36 > perl-ExtUtils-PkgConfig-1.07-31 > perl-Encode-JIS2K-0.02-32 > perl-MP3-Info-1.13-31 > perl-Regexp-Common-2.120-32 > perl-MIME-Lite-3.01-173 > perl-Devel-CoreStack-1.3-89 > perl-DBD-XBase-0.241-59 > perl-Locale-Maketext-Lexicon-0.62-17 > perl-PDA-Pilot-0.12.1-27 > perl-IO-stringy-2.110-31 > perl-NetAddr-IP-3.32-20 > perl-Test-Pod-Coverage-1.08-8 > perl-Unix-Syslog-0.100-59 > perl-IO-Stty-.02-550 > perl-IO-Socket-SSL-1.01-19 > perl-Net-Server-0.94-18 > perl-Crypt-CBC-2.19-17 > perl-XML-SAX-0.12-35 > perl-Class-Accessor-0.27-20 > perl-Module-Build-0.2805-8 > perl-Arch-0.5.1-34 > perl-FileHandle-Unget-0.1621-30 > perl-Mail-SPF-Query-1.999.1-20 > perl-Quantum-Superpositions-2.02-153 > perl-Qt-3.008-180 > perl-XML-XSLT-0.48-59 > perl-Gtk2-1.140-24 > perl-XML-Generator-0.99-34 > perl-Net-XMPP-1.0-35 > perl-OpenCA-X509-0.9.47-104 > perl-Wx-0.59-14 > perl-gettext-1.05-31 > perl-Cyrus-SIEVE-managesieve-2.2.13-24 > limal-ca-mgm-perl-1.2.9-4 > perl-Convert-ASN1-0.20-20 > perl-IO-Socket-INET6-2.51-31 > perl-CursesWidgets-1.997-34 > perl-Crypt-Blowfish-2.10-31 > perl-Socket6-0.18-31 > perl-Set-Scalar-1.20-30 > perl-Class-Multimethods-1.70-465 > perl-Getopt-Mixed-1.008-217 > perl-CDDB_get-2.27-30 > perl-GDGraph-1.43-43 > perl-AppConfig-1.63-17 > perl-Apache-AuthCookie-3.10-10 > perl-Algorithm-Annotate-0.10-34 > perl-XML-LibXML-Common-0.13-35 > perl-Devel-Symdump-2.0604-12 > perl-RPC-XML-0.59-21 > perl-Net_SSLeay-1.30-32 > perl-NetxAP-0.02-588 > perl-razor-agents-2.77-30 > perl-Pod-HtmlPsPdf-0.04-381 > perl-Class-Inspector-1.16-8 > perl-Apache2-AuthCookieDBI-2.03-8 > perl-MLDBM-Sync-0.30-276 > perl-Module-Pluggable-3.1-8 > perl-Alien-wxWidgets-0.22-14 > perl-Spreadsheet-ParseExcel-0.31-5.1.opensuse10.2.rf > perl-Data-ShowTable-3.3-602 > perl-URI-1.35-33 > perl-Config-Crontab-1.20-10 > perl-DBD-Pg-1.49-22 > perl-TermReadLine-Gnu-1.15-32 > perl-bp-0.7-36 > perl-YAML-0.62-8 > perl-Net-IRC-0.75-10 > perl-HTML-Template-JIT-0.05-30 > perl-Clone-0.22-12 > perl-Class-Autouse-1.18-32 > perl-Calendar-Simple-1.17-8 > perl-Parse-Yapp-1.05-421 > perl-Font-AFM-1.19-79 > perl-Apache-DBI-1.03-20 > perl-File-Type-0.22-34 > perl-ExtUtils-ParseXS-2.16-8 > perl-Time-Duration-1.04-20 > perl-SGMLS-1.03ii-415 > perl-Tie-Cache-0.17-274 > perl-Inline-0.44-224 > perl-Text-DelimMatch-1.06-75 > perl-WeakRef-0.01-14 > perl-Net-SNMP-5.2.0-30 > perl-HTML-Template-Expr-0.07-20 > perl-GD-Graph3d-0.63-42 > perl-Expect-1.20-16 > perl-Log-Dispatch-2.13-8 > perl-XML-Stream-1.22-34 > perl-OpenCA-OpenSSL-0.9.91-105 > perl-OpenCA-REQ-0.9.52-93 >

That is because of this line in xls2csv: # We assume the line is blank if there is nothing in the first column. last if $Col == $Sheet->{MinCol} and !$Value; This is mentioned in the CAVEATS sectio of the perldoc: A line in the spreadsheet is assumed to be blank if there is nothing in the first column. You could remove the line to avoid this behaviour.