in reply to Win32:: OLE Finding Merged Cells in Excel
If you have a sheet (e.g. by getting it with the following code)
you can check a cell by addressing its row/column to get its address:my $sheet = $Excel->Workbooks->Open($ARGV[0])->Sheets->item("words");
If the cell is merged, the address will be a range - and contain a colon (:) ... so you only need to check for that :-)$sheet->Range("$col$row")->{'MergeArea'}->{'Address'}
|
|---|