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

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!

Replies are listed 'Best First'.
Re^5: Read Merge cell details from xls
by NetWallah (Canon) on Sep 19, 2016 at 13:43 UTC
    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