function to get the value of the merged cell

mergedcellvalue

## usage:
## PHP Excel
## $objPHPExcel->setActiveSheetIndex(1);
## $objSheet = $objPHPExcel->getActiveSheet();
##

function mergedcellvalue($objSheet, $cell)
{

	foreach ($objSheet->getMergeCells() as $key => $cellarea) {
		if($objSheet->getCell($cell)->isInRange($cellarea)){
			return $objSheet->getCell(array_shift(explode(":", $cellarea)))->getValue();
		}
	}
	return $objSheet->getCell($cell)->getValue();
}