in reply to Spreadsheet::XLSX Values into DB Help!

Why are you stuck on that line?
  • Comment on Re: Spreadsheet::XLSX Values into DB Help!

Replies are listed 'Best First'.
Re^2: Spreadsheet::XLSX Values into DB Help!
by Anonymous Monk on Jul 26, 2012 at 15:31 UTC
    This should mean what you are looking for:
    ... foreach my $col ($sheet -> {MinCol} .. $sheet -> {MaxCol}) { my $cell = $sheet -> {Cells} [$row] [$col]; if ($cell) { #printf("( %s , %s ) => %s<br>", $row, $col, $cell -> +{Val}); my $name_val = $sheet->{Cells}[$row][0]->{Val}; my $address_val = $sheet->{Cells}[$row][1]->{Val}; print "\n\n Test Results::: $name_val -> $address_val\ +n"; } } ...
      Well, I wasn't looking for anything, except a reason why the OP was stuck on a line of code, and I don't understand how your answer means that, but thanks anyway...