Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Comment on

( #3333=superdoc: print w/ replies, xml ) Need Help??

reaper9187:

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.)

...roboticus

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


In reply to Re^2: Using cell_handler spreadsheetparse excel for multiple files by roboticus
in thread 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!
  • 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, 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, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            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.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others chilling in the Monastery: (7)
    As of 2014-11-28 22:19 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      My preferred Perl binaries come from:














      Results (200 votes), past polls