doy / spreadsheet-parsexlsx

parse XLSX files
http://metacpan.org/release/Spreadsheet-ParseXLSX
27 stars 35 forks source link

XLSX file cannot be parsed with Perl 5.22.3 64 bits under Windows 10 #84

Open gosseynaj opened 6 years ago

gosseynaj commented 6 years ago

Hi all, I uses to work with Spreadsheet-parseXLSX 0.27 with other projects without any problem, when here with a larger file than usual, it does want to be parsed. It's loading and the script seams to be blocked while the memory quantity used by the Perl interpreter grows second after second.

The XLSX file does not contain any particular style and is text only (data). It's size was around 16 Mb and I reduced it to 2.4 Mb : same issue.

Here is a fraction of the Perl code (extract) :

use diagnostics;
use Spreadsheet::ParseXLSX;
$xlsx_file      = "CLIENT.xlsx";
my $output_file = "EXP_CLIENT.txt";
print "Processing file $xlsx_file => $output_file.\n";
my $parser = Spreadsheet::ParseXLSX->new;
my $workbook = $parser->parse($xlsx_file);
goto END;

The script successfully prints the "Processing the CLIENT.xlsx file => EXP_CLIENT.txt" message than hangs. It never reaches the END label.

Thank you for your help. Alan.

PS : the original file can be available on demand. This is sensitive data.