chafelix has asked for the wisdom of the Perl Monks concerning the following question:
I am using Spreadsheet:Parsexlsx to read an excel file. I need to say "if this is a merged cell, then...."
I used ptkdb to see what attributes there are. So each cell has
-Col and Row ( numbers)
-Format with keys (AlignH,AlignV, BdrColor, BdrDiag,Bdrstyle)
-Fill (an array)
-FmtIdx (a number)
-Font (another hash ref)
-FontNo
-Hiden
-a number of Ignores
-FormatNo
-Rich
-Sheet
-Type
_Val and value
-Lock
-Rotate
-Shrink
-Wrap, (all these numbers)
The problem is none of these seem to have the info I need. Any ideas?
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Spreadsheet::ParseXLSX question on merged cells
by ysth (Canon) on Nov 13, 2025 at 02:01 UTC | |
by chafelix (Acolyte) on Nov 13, 2025 at 19:50 UTC | |
by ysth (Canon) on Nov 13, 2025 at 21:22 UTC | |
by chafelix (Acolyte) on Nov 13, 2025 at 21:37 UTC | |
by choroba (Cardinal) on Nov 13, 2025 at 22:49 UTC | |
|
Re: Spreadsheet::ParseXLSX question on merged cells
by starX (Chaplain) on Nov 14, 2025 at 16:58 UTC |