in reply to Win32:: OLE Finding Merged Cells in Excel

Hi

If you have a sheet (e.g. by getting it with the following code)

my $sheet = $Excel->Workbooks->Open($ARGV[0])->Sheets->item("words");
you can check a cell by addressing its row/column to get its address:
$sheet->Range("$col$row")->{'MergeArea'}->{'Address'}
If the cell is merged, the address will be a range - and contain a colon (:) ... so you only need to check for that :-)


HTH, Rata