in reply to Read Merge cell details from xls

The documentation for API access to merged cells is sparse, and implementation of individual cell merged attributes depends on the sub-module selected.

Here is a link to the Microsoft "mergearea" API call.

I think you can get the equivalent of that merged range information if you use the spreadsheet (not cell) object: 

My $mergedAreas = $ss->{merged}; # Gets AOA

[download]

        ...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^2: Read Merge cell details from xls
by Himaja (Novice) on Sep 18, 2016 at 16:11 UTC

    Hi, as I mentioned earlier, my spreadsheet object does not have the "merged" entry that you asked me to use. Could it be a version issue? Thanks.

[reply]
      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

[reply]

        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]

In Section Seekers of Perl Wisdom