Skip Menu |

This queue is for tickets about the Spreadsheet-Read CPAN distribution.

Report information
The Basics
Id: 121639
Status: rejected
Priority: 0/
Queue: Spreadsheet-Read

People
Owner: Nobody in particular
Requestors: vi.le [...] autistici.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: Error message "Parser for XLS is not installed at XXXX" when packaging with PAR::Packer
Hello, I'm trying to package Spreadsheet::Read with PAR::Packer to use the module on a system that doesn't have perl installed (a debian 8 box). It creates a executable that includes my script (attached) and its dependencies. When running the executable, I have the error message "Parser for XLS is not installed at script/test_xls.pl line 5." Here is what I've done : cpan install PAR::Packer PAR Spreadsheet::Read Spreadsheet::ParseExcel pp -M Spreadsheet::** test_xls.pl -o test_xls [scp the excel file to the target machine and run the executable] ./test_xls error : Parser for XLS is not installed at script/test_xls.pl line 5 The line that trigger the error is here https://metacpan.org/source/HMBRAND/Spreadsheet-Read-0.70/Read.pm#L581 On my computer (not the target machine) the scripts works fine. So Spreadsheet::Read seems to fail to find Spreadsheet::ParseExcel, although this module is present in the executable (you can unzip the executable to see what's in it). So what Spreadsheet::Read needs to find Spreadsheet::ParseExcel and run it? Regards, Vincent
Subject: test_xls.pl
use strict; use Spreadsheet::Read; use warnings; my $book = Spreadsheet::Read->new('test.xls', 'attr' => 1, parser => 'xls');
Subject: Re: [rt.cpan.org #121639] Error message "Parser for XLS is not installed at XXXX" when packaging with PAR::Packer
Date: Sat, 13 May 2017 09:49:05 +0200
To: bug-Spreadsheet-Read [...] rt.cpan.org
From: "H.Merijn Brand" <h.m.brand [...] xs4all.nl>
On Fri, 12 May 2017 12:12:00 -0400, "Vincent Lequertier via RT" <bug-Spreadsheet-Read@rt.cpan.org> wrote: Show quoted text
> I'm trying to package Spreadsheet::Read with PAR::Packer to use the > module on a system that doesn't have perl installed (a debian 8 box). > It creates a executable that includes my script (attached) and its > dependencies. When running the executable, I have the error message > "Parser for XLS is not installed at script/test_xls.pl line 5."
From the docs: DESCRIPTION Spreadsheet::Read tries to transparently read *any* spreadsheet and return its content in a universal manner independent of the parsing module that does the actual spreadsheet scanning. For OpenOffice and/or LibreOffice this module uses Spreadsheet::ReadSXC <http://metacpan.org/release/Spreadsheet-ReadSXC> For Microsoft Excel this module uses Spreadsheet::ParseExcel <http://metacpan.org/release/Spreadsheet-ParseExcel>, Spreadsheet::ParseXLSX <http://metacpan.org/release/Spreadsheet- Show quoted text
ParseXLSX>, or Spreadsheet::XLSX
<http://metacpan.org/release/Spreadsheet-XLSX> (discouraged). For CSV this module uses Text::CSV_XS <http://metacpan.org/release/Text-CSV_XS> or Text::CSV_PP <http://metacpan.org/release/Text-CSV_PP>. For SquirrelCalc there is a very simplistic built-in parser What this implies is that Spreadsheet::Read itself doesn't do any parsing for XLS or XLSX: it uses any of the *OPTIONALLY* installed XLS parsers on your system. Your distribution thus should include the parser you require, as it is not a requirement for Spreadsheet::Read. Say you want to use Spreadsheet::Read for CSV only, why would you install a XLS parser in your distribution (plus all its dependencies). Bottom line is, that all modules that Spreadsheet::Read supports are optional and no hard requirement. You should explicitely state what you require on the other side. As I have no experience with PAR::Packer, you'll have to find out yourself how to do that. I'll close this ticket as invalid, as it is obviously not a problem in Spreadsheet::Read. Thanks for using it though and your feedback. -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using perl5.00307 .. 5.25 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/
Download (untitled)
application/pgp-signature 473b

Message body not shown because it is not plain text.