PHPOffice / PhpSpreadsheet

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader04.php

Indentation +1 added lines, -1 removed lines

@@ -46,7 +46,7 @@
 /**  Use the PHPExcel object's getSheetNames() method to get an array listing the names/titles of the WorkSheets in the WorkBook  */
 $sheetNames = $objPHPExcel->getSheetNames();
 foreach($sheetNames as $sheetIndex => $sheetName) {
-	echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
+    echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
 }
 
 

Spacing +3 added lines, -3 removed lines

@@ -40,13 +40,13 @@
 echo 'Reading the number of Worksheets in the WorkBook<br />';
 /**  Use the PHPExcel object's getSheetCount() method to get a count of the number of WorkSheets in the WorkBook  */
 $sheetCount = $objPHPExcel->getSheetCount();
-echo 'There ',(($sheetCount == 1) ? 'is' : 'are'),' ',$sheetCount,' WorkSheet',(($sheetCount == 1) ? '' : 's'),' in the WorkBook<br /><br />';
+echo 'There ', (($sheetCount == 1) ? 'is' : 'are'), ' ', $sheetCount, ' WorkSheet', (($sheetCount == 1) ? '' : 's'), ' in the WorkBook<br /><br />';
 
 echo 'Reading the names of Worksheets in the WorkBook<br />';
 /**  Use the PHPExcel object's getSheetNames() method to get an array listing the names/titles of the WorkSheets in the WorkBook  */
 $sheetNames = $objPHPExcel->getSheetNames();
-foreach($sheetNames as $sheetIndex => $sheetName) {
-	echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
+foreach ($sheetNames as $sheetIndex => $sheetName) {
+	echo 'WorkSheet #', $sheetIndex, ' is named "', $sheetName, '"<br />';
 }
 
 

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader02.php

Indentation +1 added lines, -1 removed lines

@@ -42,7 +42,7 @@
 
 echo '<b>Custom Property names: </b><br />';
 foreach($customPropertyList as $customPropertyName) {
-	echo $customPropertyName,'<br />';
+    echo $customPropertyName,'<br />';
 }
 
 

Spacing +2 added lines, -2 removed lines

@@ -41,8 +41,8 @@
 $customPropertyList = $objPHPExcel->getProperties()->getCustomProperties();
 
 echo '<b>Custom Property names: </b><br />';
-foreach($customPropertyList as $customPropertyName) {
-	echo $customPropertyName,'<br />';
+foreach ($customPropertyList as $customPropertyName) {
+	echo $customPropertyName, '<br />';
 }
 
 

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader03.php

Indentation +28 added lines, -28 removed lines

@@ -43,34 +43,34 @@
 echo '<b>Custom Properties: </b><br />';
 /**  Loop through the list of custom properties  **/
 foreach($customPropertyList as $customPropertyName) {
-	echo '<b>',$customPropertyName,': </b>';
-	/**  Retrieve the property value  **/
-	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
-	/**  Retrieve the property type  **/
-	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customPropertyName);
-
-	/**  Manipulate properties as appropriate for display purposes  **/
-	switch($propertyType) {
-		case 'i' :	//	integer
-			$propertyType = 'integer number';
-			break;
-		case 'f' :	//	float
-			$propertyType = 'floating point number';
-			break;
-		case 's' :	//	string
-			$propertyType = 'string';
-			break;
-		case 'd' :	//	date
-			$propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A',$propertyValue);
-			$propertyType = 'date';
-			break;
-		case 'b' :	//	boolean
-			$propertyValue = ($propertyValue) ? 'TRUE' : 'FALSE';
-			$propertyType = 'boolean';
-			break;
-	}
-
-	echo $propertyValue,' (',$propertyType,')<br />';
+    echo '<b>',$customPropertyName,': </b>';
+    /**  Retrieve the property value  **/
+    $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
+    /**  Retrieve the property type  **/
+    $propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customPropertyName);
+
+    /**  Manipulate properties as appropriate for display purposes  **/
+    switch($propertyType) {
+        case 'i' :	//	integer
+            $propertyType = 'integer number';
+            break;
+        case 'f' :	//	float
+            $propertyType = 'floating point number';
+            break;
+        case 's' :	//	string
+            $propertyType = 'string';
+            break;
+        case 'd' :	//	date
+            $propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A',$propertyValue);
+            $propertyType = 'date';
+            break;
+        case 'b' :	//	boolean
+            $propertyValue = ($propertyValue) ? 'TRUE' : 'FALSE';
+            $propertyType = 'boolean';
+            break;
+    }
+
+    echo $propertyValue,' (',$propertyType,')<br />';
 }
 
 

Spacing +5 added lines, -5 removed lines

@@ -42,15 +42,15 @@ 
 
 echo '<b>Custom Properties: </b><br />';
 /**  Loop through the list of custom properties  **/
-foreach($customPropertyList as $customPropertyName) {
-	echo '<b>',$customPropertyName,': </b>';
+foreach ($customPropertyList as $customPropertyName) {
+	echo '<b>', $customPropertyName, ': </b>';
 	/**  Retrieve the property value  **/
 	$propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
 	/**  Retrieve the property type  **/
 	$propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customPropertyName);
 
 	/**  Manipulate properties as appropriate for display purposes  **/
-	switch($propertyType) {
+	switch ($propertyType) {
 		case 'i' :	//	integer
 			$propertyType = 'integer number';
 			break;
@@ -61,7 +61,7 @@ 
 			$propertyType = 'string';
 			break;
 		case 'd' :	//	date
-			$propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A',$propertyValue);
+			$propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A', $propertyValue);
 			$propertyType = 'date';
 			break;
 		case 'b' :	//	boolean
@@ -70,7 +70,7 @@ 
 			break;
 	}
 
-	echo $propertyValue,' (',$propertyType,')<br />';
+	echo $propertyValue, ' (', $propertyType, ')<br />';
 }
 
 

Documentation/Examples/Reader/exampleReader09.php

Indentation +9 added lines, -9 removed lines

@@ -37,15 +37,15 @@
 

 class MyReadFilter implements PHPExcel_Reader_IReadFilter

 {

-	public function readCell($column, $row, $worksheetName = '') {

-		// Read rows 1 to 7 and columns A to E only

-		if ($row >= 1 && $row <= 7) {

-			if (in_array($column,range('A','E'))) {

-				return true;

-			}

-		}

-		return false;

-	}

+    public function readCell($column, $row, $worksheetName = '') {

+        // Read rows 1 to 7 and columns A to E only

+        if ($row >= 1 && $row <= 7) {

+            if (in_array($column,range('A','E'))) {

+                return true;

+            }

+        }

+        return false;

+    }

 }

 

 $filterSubset = new MyReadFilter();

Spacing +4 added lines, -4 removed lines

@@ -40,7 +40,7 @@ 
 	public function readCell($column, $row, $worksheetName = '') {

 		// Read rows 1 to 7 and columns A to E only

 		if ($row >= 1 && $row <= 7) {

-			if (in_array($column,range('A','E'))) {

+			if (in_array($column, range('A', 'E'))) {

 				return true;

 			}

 		}

@@ -51,9 +51,9 @@ 
 $filterSubset = new MyReadFilter();

 

 

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

-echo 'Loading Sheet "',$sheetname,'" only<br />';

+echo 'Loading Sheet "', $sheetname, '" only<br />';

 $objReader->setLoadSheetsOnly($sheetname);

 echo 'Loading Sheet using filter<br />';

 $objReader->setReadFilter($filterSubset);

@@ -62,7 +62,7 @@ 
 

 echo '<hr />';

 

-$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

 var_dump($sheetData);

 

 

Documentation/Examples/Reader/exampleReader01.php

Spacing +2 added lines, -2 removed lines

@@ -27,13 +27,13 @@
 

 

 $inputFileName = './sampleData/example1.xls';

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory to identify the format<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory to identify the format<br />';

 $objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

 

 

 echo '<hr />';

 

-$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

 var_dump($sheetData);

 

 

Documentation/Examples/Reader/exampleReader13.php

Indentation +9 added lines, -9 removed lines

@@ -35,10 +35,10 @@ 
 $objPHPExcel = $objReader->load($inputFileName);

 $objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));

 foreach($inputFileNames as $sheet => $inputFileName) {

-	echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' into WorkSheet #',($sheet+2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

-	$objReader->setSheetIndex($sheet+1);

-	$objReader->loadIntoExisting($inputFileName,$objPHPExcel);

-	$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));

+    echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' into WorkSheet #',($sheet+2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+    $objReader->setSheetIndex($sheet+1);

+    $objReader->loadIntoExisting($inputFileName,$objPHPExcel);

+    $objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));

 }

 

 

@@ -47,11 +47,11 @@ 
 echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';

 $loadedSheetNames = $objPHPExcel->getSheetNames();

 foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';

-	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

-	var_dump($sheetData);

-	echo '<br /><br />';

+    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';

+    $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

+    $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+    var_dump($sheetData);

+    echo '<br /><br />';

 }

 

 

Spacing +12 added lines, -12 removed lines

@@ -27,29 +27,29 @@
 

 

 $inputFileType = 'CSV';

-$inputFileNames = array('./sampleData/example1.csv','./sampleData/example2.csv');

+$inputFileNames = array('./sampleData/example1.csv', './sampleData/example2.csv');

 

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

 $inputFileName = array_shift($inputFileNames);

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 $objPHPExcel = $objReader->load($inputFileName);

-$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));

-foreach($inputFileNames as $sheet => $inputFileName) {

-	echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' into WorkSheet #',($sheet+2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

-	$objReader->setSheetIndex($sheet+1);

-	$objReader->loadIntoExisting($inputFileName,$objPHPExcel);

-	$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));

+$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));

+foreach ($inputFileNames as $sheet => $inputFileName) {

+	echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #', ($sheet + 2), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';

+	$objReader->setSheetIndex($sheet + 1);

+	$objReader->loadIntoExisting($inputFileName, $objPHPExcel);

+	$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));

 }

 

 

 echo '<hr />';

 

-echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';

+echo $objPHPExcel->getSheetCount(), ' worksheet', (($objPHPExcel->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';

 $loadedSheetNames = $objPHPExcel->getSheetNames();

-foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';

+foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

+	echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, '</b><br />';

 	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

 	var_dump($sheetData);

 	echo '<br /><br />';

 }

Documentation/Examples/Reader/exampleReader15.php

Indentation +15 added lines, -15 removed lines

@@ -39,31 +39,31 @@
 echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';

 $loadedSheetNames = $objPHPExcel->getSheetNames();

 foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />';

-	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

-	var_dump($sheetData);

-	echo '<br />';

+    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />';

+    $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

+    $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+    var_dump($sheetData);

+    echo '<br />';

 }

 

 echo '<hr />';

 

 foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Unformatted)</b><br />';

-	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,false,true);

-	var_dump($sheetData);

-	echo '<br />';

+    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Unformatted)</b><br />';

+    $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

+    $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,false,true);

+    var_dump($sheetData);

+    echo '<br />';

 }

 

 echo '<hr />';

 

 foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Raw)</b><br />';

-	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,false,false,true);

-	var_dump($sheetData);

-	echo '<br />';

+    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Raw)</b><br />';

+    $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

+    $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,false,false,true);

+    var_dump($sheetData);

+    echo '<br />';

 }

 

 ?>

Spacing +13 added lines, -13 removed lines

@@ -21,47 +21,47 @@
 include 'PHPExcel/IOFactory.php';

 

 

-PHPExcel_Cell::setValueBinder( new PHPExcel_Cell_AdvancedValueBinder() );

+PHPExcel_Cell::setValueBinder(new PHPExcel_Cell_AdvancedValueBinder());

 

 

 $inputFileType = 'CSV';

 $inputFileName = './sampleData/example1.tsv';

 

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 $objReader->setDelimiter("\t");

 $objPHPExcel = $objReader->load($inputFileName);

-$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));

+$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));

 

 

 echo '<hr />';

 

-echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';

+echo $objPHPExcel->getSheetCount(), ' worksheet', (($objPHPExcel->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';

 $loadedSheetNames = $objPHPExcel->getSheetNames();

-foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />';

+foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

+	echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Formatted)</b><br />';

 	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

 	var_dump($sheetData);

 	echo '<br />';

 }

 

 echo '<hr />';

 

-foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Unformatted)</b><br />';

+foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

+	echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Unformatted)</b><br />';

 	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,false,true);

+	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, false, true);

 	var_dump($sheetData);

 	echo '<br />';

 }

 

 echo '<hr />';

 

-foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Raw)</b><br />';

+foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

+	echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Raw)</b><br />';

 	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,false,false,true);

+	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, false, false, true);

 	var_dump($sheetData);

 	echo '<br />';

 }

Documentation/Examples/Reader/exampleReader06.php

Spacing +4 added lines, -4 removed lines

@@ -33,7 +33,7 @@ 
 //	$inputFileType = 'Gnumeric';

 $inputFileName = './sampleData/example1.xls';

 

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

 echo 'Loading all WorkSheets<br />';

 $objReader->setLoadAllSheets();

@@ -42,10 +42,10 @@ 
 

 echo '<hr />';

 

-echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';

+echo $objPHPExcel->getSheetCount(), ' worksheet', (($objPHPExcel->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';

 $loadedSheetNames = $objPHPExcel->getSheetNames();

-foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo $sheetIndex,' -> ',$loadedSheetName,'<br />';

+foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

+	echo $sheetIndex, ' -> ', $loadedSheetName, '<br />';

 }

 

 

Indentation +1 added lines, -1 removed lines

@@ -46,7 +46,7 @@
 echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';

 $loadedSheetNames = $objPHPExcel->getSheetNames();

 foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo $sheetIndex,' -> ',$loadedSheetName,'<br />';

+    echo $sheetIndex,' -> ',$loadedSheetName,'<br />';

 }

 

 

Documentation/Examples/Reader/exampleReader11.php

Indentation +30 added lines, -30 removed lines

@@ -37,23 +37,23 @@ 
 /**  Define a Read Filter class implementing PHPExcel_Reader_IReadFilter  */

 class chunkReadFilter implements PHPExcel_Reader_IReadFilter

 {

-	private $_startRow = 0;

-

-	private $_endRow = 0;

-

-	/**  We expect a list of the rows that we want to read to be passed into the constructor  */

-	public function __construct($startRow, $chunkSize) {

-		$this->_startRow	= $startRow;

-		$this->_endRow		= $startRow + $chunkSize;

-	}

-

-	public function readCell($column, $row, $worksheetName = '') {

-		//  Only read the heading row, and the rows that were configured in the constructor

-		if (($row == 1) || ($row >= $this->_startRow && $row < $this->_endRow)) {

-			return true;

-		}

-		return false;

-	}

+    private $_startRow = 0;

+

+    private $_endRow = 0;

+

+    /**  We expect a list of the rows that we want to read to be passed into the constructor  */

+    public function __construct($startRow, $chunkSize) {

+        $this->_startRow	= $startRow;

+        $this->_endRow		= $startRow + $chunkSize;

+    }

+

+    public function readCell($column, $row, $worksheetName = '') {

+        //  Only read the heading row, and the rows that were configured in the constructor

+        if (($row == 1) || ($row >= $this->_startRow && $row < $this->_endRow)) {

+            return true;

+        }

+        return false;

+    }

 }

 

 

@@ -70,19 +70,19 @@ 
 

 /**  Loop to read our worksheet in "chunk size" blocks  **/

 for ($startRow = 2; $startRow <= 240; $startRow += $chunkSize) {

-	echo 'Loading WorkSheet using configurable filter for headings row 1 and for rows ',$startRow,' to ',($startRow+$chunkSize-1),'<br />';

-	/**  Create a new Instance of our Read Filter, passing in the limits on which rows we want to read  **/

-	$chunkFilter = new chunkReadFilter($startRow,$chunkSize);

-	/**  Tell the Reader that we want to use the new Read Filter that we've just Instantiated  **/

-	$objReader->setReadFilter($chunkFilter);

-	/**  Load only the rows that match our filter from $inputFileName to a PHPExcel Object  **/

-	$objPHPExcel = $objReader->load($inputFileName);

-

-	//	Do some processing here

-

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

-	var_dump($sheetData);

-	echo '<br /><br />';

+    echo 'Loading WorkSheet using configurable filter for headings row 1 and for rows ',$startRow,' to ',($startRow+$chunkSize-1),'<br />';

+    /**  Create a new Instance of our Read Filter, passing in the limits on which rows we want to read  **/

+    $chunkFilter = new chunkReadFilter($startRow,$chunkSize);

+    /**  Tell the Reader that we want to use the new Read Filter that we've just Instantiated  **/

+    $objReader->setReadFilter($chunkFilter);

+    /**  Load only the rows that match our filter from $inputFileName to a PHPExcel Object  **/

+    $objPHPExcel = $objReader->load($inputFileName);

+

+    //	Do some processing here

+

+    $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+    var_dump($sheetData);

+    echo '<br /><br />';

 }

 

 

Spacing +6 added lines, -6 removed lines

@@ -43,8 +43,8 @@ 
 

 	/**  We expect a list of the rows that we want to read to be passed into the constructor  */

 	public function __construct($startRow, $chunkSize) {

-		$this->_startRow	= $startRow;

-		$this->_endRow		= $startRow + $chunkSize;

+		$this->_startRow = $startRow;

+		$this->_endRow = $startRow + $chunkSize;

 	}

 

 	public function readCell($column, $row, $worksheetName = '') {

@@ -57,7 +57,7 @@ 
 }

 

 

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 /**  Create a new Reader of the type defined in $inputFileType  **/

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

 

@@ -70,9 +70,9 @@ 
 

 /**  Loop to read our worksheet in "chunk size" blocks  **/

 for ($startRow = 2; $startRow <= 240; $startRow += $chunkSize) {

-	echo 'Loading WorkSheet using configurable filter for headings row 1 and for rows ',$startRow,' to ',($startRow+$chunkSize-1),'<br />';

+	echo 'Loading WorkSheet using configurable filter for headings row 1 and for rows ', $startRow, ' to ', ($startRow + $chunkSize - 1), '<br />';

 	/**  Create a new Instance of our Read Filter, passing in the limits on which rows we want to read  **/

-	$chunkFilter = new chunkReadFilter($startRow,$chunkSize);

+	$chunkFilter = new chunkReadFilter($startRow, $chunkSize);

 	/**  Tell the Reader that we want to use the new Read Filter that we've just Instantiated  **/

 	$objReader->setReadFilter($chunkFilter);

 	/**  Load only the rows that match our filter from $inputFileName to a PHPExcel Object  **/

@@ -80,7 +80,7 @@ 
 

 	//	Do some processing here

 

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

 	var_dump($sheetData);

 	echo '<br /><br />';

 }