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:
    #!/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";

    }

[download]
It isnt working obviously .. please help ...

In reply to Using cell_handler spreadsheetparse excel for multiple files by reaper9187

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.