in reply to Re^2: Read Merge cell details from xls
in thread Read Merge cell details from xls

Sorry - I'm not familiar with the module.

You have not said what program/version generated the spreadsheet, he version of the module, or what your platform/os is. Perhaps there is a dependency there.

Another possibility is that the key "merged" may have a different name, in your module version. Check for keys of %$ss, to see if any of them sound like "merged".

Just trying to be helpful, but I'm out of suggestions at this point.

        ...it is unhealthy to remain near things that are in the process of blowing up.     man page for WARP, by Larry Wall

Replies are listed 'Best First'.
Re^4: Read Merge cell details from xls
by Himaja (Novice) on Sep 19, 2016 at 08:29 UTC

    I am running my script on a RedHat 6.0 machine using version 5.10.1 for perl. Have tried using 5.14.2 as well. There are no keys that remotely sound like merged info. From the description given here, http://search.cpan.org/~hmbrand/Spreadsheet-Read/Read.pm I can see all entries except the merged key in my book. Other than that, each cell in the attr key has a "merged" info. But I am getting merged = 0 on merged cells as well. Thanks!

[reply]
      I see this code in the module source: 
      $sheet{merged} = [
        map  {  $_->[0] }
        sort {  $a->[1] cmp $b->[1] }
        map  {[ $_, pack "NNNN", @$_          ]}
        map  {[ map { $_ + 1 } @{$_}[1,0,3,2] ]}
        @{$oWkS->get_merged_areas || []}];

      [download]
      This seems to indicate that "merged" is a WORKSHEET attribute - would you care to investigate that ?

              ...it is unhealthy to remain near things that are in the process of blowing up.     man page for WARP, by Larry Wall

[reply]
[d/l]

        Hey I am NOT able find the mentioned merged attribute in my worksheet even after reading the sheet with the following command.

        my $book = ReadData("Temp_test.xlsx",attr=>1,merge=>1);
[reply]
[d/l]

In Section Seekers of Perl Wisdom