PHPOffice / PhpSpreadsheet

Documentation/Examples/Reader/exampleReader08.php

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/exampleReader14.php

Indentation +27 added lines, -27 removed lines

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

 class chunkReadFilter implements PHPExcel_Reader_IReadFilter

 {

-	private $_startRow = 0;

-

-	private $_endRow = 0;

-

-	/**  Set the list of rows that we want to read  */

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

-		$this->_startRow	= $startRow;

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

-	}

-

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

-		//  Only read the heading row, and the rows that are configured in $this->_startRow and $this->_endRow

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

-			return true;

-		}

-		return false;

-	}

+    private $_startRow = 0;

+

+    private $_endRow = 0;

+

+    /**  Set the list of rows that we want to read  */

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

+        $this->_startRow	= $startRow;

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

+    }

+

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

+        //  Only read the heading row, and the rows that are configured in $this->_startRow and $this->_endRow

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

+            return true;

+        }

+        return false;

+    }

 }

 

 

@@ -63,7 +63,7 @@ 
 /**  Tell the Reader that we want to use the Read Filter that we've Instantiated  **/

 /**    and that we want to store it in contiguous rows/columns  **/

 $objReader->setReadFilter($chunkFilter)

-		  ->setContiguous(true);

+            ->setContiguous(true);

 

 

 /**  Instantiate a new PHPExcel object manually  **/

@@ -74,13 +74,13 @@ 
 /**  Loop to read our worksheet in "chunk size" blocks  **/

 /**  $startRow is set to 2 initially because we always read the headings in row #1  **/

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

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

-	/**  Tell the Read Filter, the limits on which rows we want to read this iteration  **/

-	$chunkFilter->setRows($startRow,$chunkSize);

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

+    /**  Tell the Read Filter, the limits on which rows we want to read this iteration  **/

+    $chunkFilter->setRows($startRow,$chunkSize);

 

     /**  Increment the worksheet index pointer for the Reader  **/

     $objReader->setSheetIndex($sheet);

-	/**  Load only the rows that match our filter into a new worksheet in the PHPExcel Object  **/

+    /**  Load only the rows that match our filter into a new worksheet in the PHPExcel Object  **/

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

     /**  Set the worksheet title (to reference the "sheet" of data that we've loaded)  **/

     /**    and increment the sheet index as well  **/

@@ -93,11 +93,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,false,false,true);

-	var_dump($sheetData);

-	echo '<br />';

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

+    $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

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

+    var_dump($sheetData);

+    echo '<br />';

 }

 

 ?>

Documentation/Examples/Reader/exampleReader18.php

Indentation +1 added lines, -1 removed lines

@@ -41,7 +41,7 @@
 echo '<h3>Worksheet Names</h3>';
 echo '<ol>';
 foreach ($worksheetNames as $worksheetName) {
-	echo '<li>', $worksheetName, '</li>';
+    echo '<li>', $worksheetName, '</li>';
 }
 echo '</ol>';
 

Documentation/Examples/Reader/exampleReader19.php

Indentation +4 added lines, -4 removed lines

@@ -41,10 +41,10 @@
 echo '<h3>Worksheet Information</h3>';
 echo '<ol>';
 foreach ($worksheetData as $worksheet) {
-	echo '<li>', $worksheet['worksheetName'], '<br />';
-	echo 'Rows: ', $worksheet['totalRows'], ' Columns: ', $worksheet['totalColumns'], '<br />';
-	echo 'Cell Range: A1:', $worksheet['lastColumnLetter'], $worksheet['totalRows'];
-	echo '</li>';
+    echo '<li>', $worksheet['worksheetName'], '<br />';
+    echo 'Rows: ', $worksheet['totalRows'], ' Columns: ', $worksheet['totalColumns'], '<br />';
+    echo 'Cell Range: A1:', $worksheet['lastColumnLetter'], $worksheet['totalRows'];
+    echo '</li>';
 }
 echo '</ol>';
 

Documentation/Examples/index.php

Indentation +16 added lines, -16 removed lines

@@ -21,28 +21,28 @@
 

 foreach($exampleTypeList as $exampleType) {

 

-	echo '<h1>PHPExcel ' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Examples</h1>';

+    echo '<h1>PHPExcel ' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Examples</h1>';

 

-	$exampleList = glob('./'.$exampleType.'/*.php');

+    $exampleList = glob('./'.$exampleType.'/*.php');

 

-	foreach($exampleList as $exampleFile) {

-		$fileData = file_get_contents($exampleFile);

+    foreach($exampleList as $exampleFile) {

+        $fileData = file_get_contents($exampleFile);

 

-		$h1Pattern = '#<h1>(.*?)</h1>#';

-		$h2Pattern = '#<h2>(.*?)</h2>#';

+        $h1Pattern = '#<h1>(.*?)</h1>#';

+        $h2Pattern = '#<h2>(.*?)</h2>#';

 

-		if (preg_match($h1Pattern, $fileData, $out)) {

-			$h1Text = $out[1];

-			$h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';

+        if (preg_match($h1Pattern, $fileData, $out)) {

+            $h1Text = $out[1];

+            $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';

 

-			echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';

-			if (($h2Text > '') &&

-				(pathinfo($exampleType,PATHINFO_BASENAME) != 'Calculations')) {

-				echo $h2Text,'<br />';

-			}

-		}

+            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';

+            if (($h2Text > '') &&

+                (pathinfo($exampleType,PATHINFO_BASENAME) != 'Calculations')) {

+                echo $h2Text,'<br />';

+            }

+        }

 

-	}

+    }

 }

 

 ?>

unitTests/Classes/src/Worksheet/WorksheetRowTest.php

Indentation +2 added lines, -2 removed lines

@@ -13,8 +13,8 @@
             ->disableOriginalConstructor()
             ->getMock();
         $this->mockWorksheet->expects($this->any())
-                 ->method('getHighestColumn')
-                 ->will($this->returnValue('E'));
+                    ->method('getHighestColumn')
+                    ->will($this->returnValue('E'));
     }
 
 

unitTests/Classes/src/Worksheet/AutoFilter/ColumnTest.php

Indentation +4 added lines, -4 removed lines

@@ -111,7 +111,7 @@ 
     {
         $attributeSet = array(    'val' => 100,
                                 'maxVal' => 200
-                             );
+                                );
 
         //    Setters return the instance to implement the fluent interface
         $result = $this->_testAutoFilterColumnObject->setAttributes($attributeSet);
@@ -122,7 +122,7 @@ 
     {
         $attributeSet = array(    'val' => 100,
                                 'maxVal' => 200
-                             );
+                                );
 
         $this->_testAutoFilterColumnObject->setAttributes($attributeSet);
 
@@ -135,7 +135,7 @@ 
     {
         $attributeSet = array(    'val' => 100,
                                 'maxVal' => 200
-                             );
+                                );
 
         foreach ($attributeSet as $attributeName => $attributeValue) {
             //    Setters return the instance to implement the fluent interface
@@ -148,7 +148,7 @@ 
     {
         $attributeSet = array(    'val' => 100,
                                 'maxVal' => 200
-                             );
+                                );
 
         $this->_testAutoFilterColumnObject->setAttributes($attributeSet);
 

unitTests/Classes/src/Worksheet/RowIteratorTest.php

Indentation +4 added lines, -4 removed lines

@@ -18,11 +18,11 @@
             ->getMock();
 
         $this->mockWorksheet->expects($this->any())
-                 ->method('getHighestRow')
-                 ->will($this->returnValue(5));
+                    ->method('getHighestRow')
+                    ->will($this->returnValue(5));
         $this->mockWorksheet->expects($this->any())
-                 ->method('current')
-                 ->will($this->returnValue($this->mockRow));
+                    ->method('current')
+                    ->will($this->returnValue($this->mockRow));
     }
 
 

unitTests/Classes/src/Worksheet/ColumnCellIteratorTest.php

Indentation +4 added lines, -4 removed lines

@@ -18,11 +18,11 @@
             ->getMock();
 
         $this->mockWorksheet->expects($this->any())
-                 ->method('getHighestRow')
-                 ->will($this->returnValue(5));
+                    ->method('getHighestRow')
+                    ->will($this->returnValue(5));
         $this->mockWorksheet->expects($this->any())
-                 ->method('getCellByColumnAndRow')
-                 ->will($this->returnValue($this->mockCell));
+                    ->method('getCellByColumnAndRow')
+                    ->will($this->returnValue($this->mockCell));
     }