Phpexcel read data from excel only values

Developers Programming
#1

Dear All
Using following code

We can read data properly
except when cell value stored is “TRUE” or “FALSE”
I get 1 and blank
I want TRUE or FALSE as text and not logical operator

How to read / get only values stored in cell

My code

include(‘PHPExcel-develop/Classes/PHPExcel/IOFactory.php’);

try {
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
} catch(Exception $e) {
die(‘Error loading file "’.pathinfo($inputFileName,PATHINFO_BASENAME).’": '.$e->getMessage());
}

$allDataInSheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$arrayCount = count($allDataInSheet);

// the to get cell data
$excelsrno=trim($allDataInSheet[$i][“A”]);
$q= trim($allDataInSheet[$i][“B”]);
$a1= trim($allDataInSheet[$i][“C”]);

		$a2= trim($allDataInSheet[$i]["D"] );	
		$a3= trim($allDataInSheet[$i]["E"] );
		$a4= trim($allDataInSheet[$i]["F"] );	
		$a= preg_replace('/[^0-9]/', '',  trim($allDataInSheet[$i]["G"]));	
	    $level=trim($allDataInSheet[$i]["H"]);	 
	    $marks=trim($allDataInSheet[$i]["I"]);