Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Using cell_handler spreadsheetparse excel for multiple files

by reaper9187 (Scribe)
on Jan 15, 2013 at 10:17 UTC ( #1013346=note: print w/replies, xml ) Need Help??

in reply to Using cell_handler spreadsheetparse excel for multiple files

Hi .. thanks for replying .. I'm actually trying to parse them simultaneously(for comparing)... how do i get around this problem ??
  • Comment on Re: Using cell_handler spreadsheetparse excel for multiple files

Replies are listed 'Best First'.
Re^2: Using cell_handler spreadsheetparse excel for multiple files
by roboticus (Chancellor) on Jan 15, 2013 at 11:36 UTC


    That depends on your (unstated) requirements: If you truly need to have the values in sheet1 and sheet2 handled at the same time, then you'll have to make a copy of the data while you process sheet 1 so you can have the data when you get around to sheet 2. Something like:

    my @TEMP; sub cell_handler { my $workbook = $_[0]; my $sheet_index = $_[1]; my $row = $_[2]; my $col = $_[3]; my $cell = $_[4]; if ($sheet_index == 1) { $TEMP[$row][$col] = $cell; } elsif ($sheet_index == 2) { print $TEMP[$row][$col]->value(),"\n"; print $cell->value(),"\n"; } }

    *However*, this relies on the parser seeing all the cells in sheet 1 before seeing sheet 2. (I don't know if that's always going to happen or not.) You could expand this code to store away *all* values and process them afterwards, but then you wouldn't need a cell_handler function, either, as you could loop over the data after the sheets are parsed.

    If the parsing order isn't guaranteed, you'll have to figure out how you would do it manually if someone were handing you cells at random, and write the code to do it that way. (You might have noticed a tagline by one of our monks to that effect.)


    When your only tool is a hammer, all problems look like your thumb.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1013346]
[marto]: I think that actually caught up with me yesterday, felt a really sharp pain where my neck meets my skull.
[Corion]: marto: Ouch, yeah...
[marto]: the boys uncle will take them for a couple of hours this afternoon :)
[marto]: only at work 3 days this week, then off to Copenhagen for a wedding
[marto]: back the following Monday, potentially gone 2-3 days the next week for work

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (5)
As of 2017-11-19 11:35 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (280 votes). Check out past polls.