Re^2: rowspan vals in Excel SS are not interpreted by ParseExcel::Simple

..oddly enough, after pushing the value into the {Val} and {_Value} fields, I figured I was good to go. But I then used:

my @row=$page->next_row;
[download]

and all of the vals I propagated in are missing.

Yet if I inspect the cell Val at the row and col, they are all correct. So I had to manually push values into the array:

for ( my $c=0; $c<=$maxCol; $c++ ) {
 next if $row[$c] =~ /./;
 $row[$c]=$page->{sheet}->[$row]->[$c]->{Val};
}
[download]

Sure didn't expect that! * * * Followup- not sure why I was seeing that- but now everything is behaving without that step.. YAY thanks guys you were all a great help.

Comment on Re^2: rowspan vals in Excel SS are not interpreted by ParseExcel::Simple Select or Download Code

Replies are listed 'Best First'.
Re^3: rowspan vals in Excel SS are not interpreted by ParseExcel::Simple by FreeBeerReekingMonk (Deacon) on Feb 09, 2017 at 20:38 UTC
See also previous explanation: The perl module uses the function Value() to retrieve the value from the variable {_Value}. So setting {Val} will not work with next_row(). `sub next_row { map { $_ ? $_->Value : "" } @{$_[0]->{sheet}->{Cells} }` [download] Now, because a spanned cell COULD hold a value() BEFORE spanning (usually empty, but not necessarily), you will get that value() instead of the spanned value... spanning is like mounting a drive over a directory that may already hold files.... but it works now, congrats!	[reply] [d/l]

Replies are listed 'Best First'.

Re^3: rowspan vals in Excel SS are not interpreted by ParseExcel::Simple
by FreeBeerReekingMonk (Deacon) on Feb 09, 2017 at 20:38 UTC

The perl module uses the function Value() to retrieve the value from the variable {_Value}. So setting {Val} will not work with next_row().

sub next_row {
  map { $_ ? $_->Value : "" } @{$_[0]->{sheet}->{Cells}
}
[download]

Now, because a spanned cell COULD hold a value() BEFORE spanning (usually empty, but not necessarily), you will get that value() instead of the spanned value...

spanning is like mounting a drive over a directory that may already hold files.... but it works now, congrats!

[reply]
[d/l]