reaper9187 has asked for the wisdom of the Perl Monks concerning the following question:
Hi Everyone,
I'm currently developing an app that will be used to parse large excel files. I have developed code without using cell handler and as expected , it takes a long time to load these files into memory before parsing it . I have read basic codes regarding the use of cell_handler .. but somehow m not able to get it completely... here's a part of my code that i was writing using the cell handler:
I'm currently developing an app that will be used to parse large excel files. I have developed code without using cell handler and as expected , it takes a long time to load these files into memory before parsing it . I have read basic codes regarding the use of cell_handler .. but somehow m not able to get it completely... here's a part of my code that i was writing using the cell handler:
It isnt working obviously .. please help ...#!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel; my $parser = Spreadsheet::ParseExcel->new( CellHandler => \&cell_handler, NotSetCell => 1 ); my $workbook1 = $parser->parse('A.xls'); my $workbook2 = $parser->parse('B.xls'); my $sheetone = $workbook1->Worksheet(0); my $sheettwo = $workbook2->Worksheet(1) ; 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 $sheetone->get_cell($row,$col)->value(),"\n"; print $sheettwo->get_cell($row,$col)->value(),"\n"; }
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Using cell_handler spreadsheetparse excel for multiple files
by tobyink (Canon) on Jan 15, 2013 at 10:08 UTC | |
Re: Using cell_handler spreadsheetparse excel for multiple files
by reaper9187 (Scribe) on Jan 15, 2013 at 10:17 UTC | |
by roboticus (Chancellor) on Jan 15, 2013 at 11:36 UTC |
Back to
Seekers of Perl Wisdom