Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

Re^5: Read Merge cell details from xls

by NetWallah (Canon)
on Sep 19, 2016 at 13:43 UTC ( [id://1172138]=note: print w/replies, xml ) Need Help??


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

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 || []}];
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

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

    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);

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1172138]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2024-04-19 21:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found