in reply to Re: Reducing the memory usage of Spreadsheet::ParseExcel
in thread Reducing the memory usage of Spreadsheet::ParseExcel
and how adapt it for my code. I have spend a lot of hours but nothing... help me please :(#!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel; my $parser = Spreadsheet::ParseExcel->new( CellHandler => \&cell_handler, NotSetCell => 1 ); my $workbook = $parser->parse('file.xls'); sub cell_handler { my $workbook = $_[0]; my $sheet_index = $_[1]; my $row = $_[2]; my $col = $_[3]; my $cell = $_[4]; # Do something useful with the formatted cell value print $cell->value(), "\n"; }
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^3: Reducing the memory usage of Spreadsheet::ParseExcel
by cibien (Novice) on Jan 23, 2013 at 07:27 UTC | |
by Anonymous Monk on Jan 23, 2013 at 07:56 UTC |