Inspection of "Show badges similar to those used for PHPWord" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — develop (d19f73)

by Adrien

created 2016-08-14 06:18 UTC

Indentation +18 added lines, -18 removed lines patch added patch discarded remove patch

@@ -33,20 +33,20 @@  discard block
 block discarded – undo
 
 // Add some data
 $testDates = array(	array(3,15),		array(13,15),	array(15,15,15),	array(3,15,30),
-					array(15,15,15),	array(5),		array(9,15,0),		array(9,15,-1),
-					array(13,-14,-15),	array(0,0,-1)
-				  );
+                    array(15,15,15),	array(5),		array(9,15,0),		array(9,15,-1),
+                    array(13,-14,-15),	array(0,0,-1)
+                    );
 $testDateCount = count($testDates);
 
 $worksheet->fromArray($testDates,NULL,'A1',true);
 
 for ($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('D'.$row, '=TIME(A'.$row.',B'.$row.',C'.$row.')');
-	$worksheet->setCellValue('E'.$row, '=D'.$row);
+    $worksheet->setCellValue('D'.$row, '=TIME(A'.$row.',B'.$row.',C'.$row.')');
+    $worksheet->setCellValue('E'.$row, '=D'.$row);
 }
 $worksheet->getStyle('E1:E'.$testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 
 echo '<hr />';
@@ -67,15 +67,15 @@  discard block
 block discarded – undo
 		<th>Second</th>
 	<tr>
 	<?php
-	for ($row = 1; $row <= $testDateCount; ++$row) {
-		echo '<tr>';
-		    echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('E'.$row)->getFormattedValue() , '</td>';
-		echo '</tr>';
-	}
-	?>
+    for ($row = 1; $row <= $testDateCount; ++$row) {
+        echo '<tr>';
+            echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('E'.$row)->getFormattedValue() , '</td>';
+        echo '</tr>';
+    }
+    ?>
 </table>
\ No newline at end of file

Please login to merge, or discard this patch.

Documentation/Examples/Calculations/DateTime/TIMEVALUE.php 1 patch

Indentation +15 added lines, -15 removed lines patch added patch discarded remove patch

@@ -33,18 +33,18 @@  discard block
 block discarded – undo
 
 // Add some data
 $testDates = array(	'3:15',	'13:15',	'15:15:15',	'3:15 AM',	'3:15 PM',	'5PM',	'9:15AM',	'13:15AM'
-				  );
+                    );
 $testDateCount = count($testDates);
 
 for($row = 1; $row <= $testDateCount; ++$row) {
-	$worksheet->setCellValue('A'.$row, $testDates[$row-1]);
-	$worksheet->setCellValue('B'.$row, '=TIMEVALUE(A'.$row.')');
-	$worksheet->setCellValue('C'.$row, '=B'.$row);
+    $worksheet->setCellValue('A'.$row, $testDates[$row-1]);
+    $worksheet->setCellValue('B'.$row, '=TIMEVALUE(A'.$row.')');
+    $worksheet->setCellValue('C'.$row, '=B'.$row);
 }
 
 $worksheet->getStyle('C1:C'.$testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 
 echo '<hr />';
@@ -60,13 +60,13 @@  discard block
 block discarded – undo
 		<th>Formatted TimeStamp</th>
 	</tr>
 	<?php
-	for ($row = 1; $row <= $testDateCount; ++$row) {
-		echo '<tr>';
-		    echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
-			echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
-		echo '</tr>';
-	}
-	?>
+    for ($row = 1; $row <= $testDateCount; ++$row) {
+        echo '<tr>';
+            echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('B'.$row)->getValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
+            echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
+        echo '</tr>';
+    }
+    ?>
 </table>
\ No newline at end of file

Please login to merge, or discard this patch.

Documentation/Examples/Calculations/index.php 1 patch

Indentation +15 added lines, -15 removed lines patch added patch discarded remove patch

@@ -23,27 +23,27 @@
 block discarded – undo
 
 foreach($exampleTypeList as $exampleType) {
 
-	echo '<h2>' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Function Examples</h2>';
+    echo '<h2>' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Function Examples</h2>';
 
-	$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 > '') {
-				echo $h2Text,'<br />';
-			}
-		}
+            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
+            if ($h2Text > '') {
+                echo $h2Text,'<br />';
+            }
+        }
 
-	}
+    }
 }
 
 ?>

Please login to merge, or discard this patch.

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader04.php 1 patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

@@ -46,7 +46,7 @@
 block discarded – undo
 /**  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 />';
 }
 
 

Please login to merge, or discard this patch.

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader02.php 1 patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

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

Please login to merge, or discard this patch.

Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader03.php 1 patch

Indentation +28 added lines, -28 removed lines patch added patch discarded remove patch

@@ -43,34 +43,34 @@
 block discarded – undo
 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 />';
 }
 
 

Please login to merge, or discard this patch.

Documentation/Examples/Reader/exampleReader09.php 1 patch

Indentation +9 added lines, -9 removed lines patch added patch discarded remove patch

@@ -37,15 +37,15 @@
 block discarded – undo
 
 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();

Please login to merge, or discard this patch.

Documentation/Examples/Reader/exampleReader13.php 1 patch

Indentation +9 added lines, -9 removed lines patch added patch discarded remove patch

@@ -35,10 +35,10 @@  discard block
 block discarded – undo
 $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 @@  discard block
 block discarded – undo
 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 />';
 }
 
 

Please login to merge, or discard this patch.

Documentation/Examples/Reader/exampleReader15.php 1 patch

Indentation +15 added lines, -15 removed lines patch added patch discarded remove patch

@@ -39,31 +39,31 @@
 block discarded – undo
 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 />';
 }
 
 ?>

Please login to merge, or discard this patch.

		@@ -33,20 +33,20 @@ discard block
		block discarded – undo
33	33
34	34	// Add some data
35	35	$testDates = array( array(3,15), array(13,15), array(15,15,15), array(3,15,30),
36		- array(15,15,15), array(5), array(9,15,0), array(9,15,-1),
37		- array(13,-14,-15), array(0,0,-1)
38		- );
	36	+ array(15,15,15), array(5), array(9,15,0), array(9,15,-1),
	37	+ array(13,-14,-15), array(0,0,-1)
	38	+ );
39	39	$testDateCount = count($testDates);
40	40
41	41	$worksheet->fromArray($testDates,NULL,'A1',true);
42	42
43	43	for ($row = 1; $row <= $testDateCount; ++$row) {
44		- $worksheet->setCellValue('D'.$row, '=TIME(A'.$row.',B'.$row.',C'.$row.')');
45		- $worksheet->setCellValue('E'.$row, '=D'.$row);
	44	+ $worksheet->setCellValue('D'.$row, '=TIME(A'.$row.',B'.$row.',C'.$row.')');
	45	+ $worksheet->setCellValue('E'.$row, '=D'.$row);
46	46	}
47	47	$worksheet->getStyle('E1:E'.$testDateCount)
48		- ->getNumberFormat()
49		- ->setFormatCode('hh:mm:ss');
	48	+ ->getNumberFormat()
	49	+ ->setFormatCode('hh:mm:ss');
50	50
51	51
52	52	echo '<hr />';
		@@ -67,15 +67,15 @@ discard block
		block discarded – undo
67	67	<th>Second</th>
68	68	<tr>
69	69	<?php
70		- for ($row = 1; $row <= $testDateCount; ++$row) {
71		- echo '<tr>';
72		- echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
73		- echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
74		- echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
75		- echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
76		- echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
77		- echo '<td>' , $worksheet->getCell('E'.$row)->getFormattedValue() , '</td>';
78		- echo '</tr>';
79		- }
80		- ?>
	70	+ for ($row = 1; $row <= $testDateCount; ++$row) {
	71	+ echo '<tr>';
	72	+ echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
	73	+ echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
	74	+ echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
	75	+ echo '<td>' , $worksheet->getCell('D'.$row)->getValue() , '</td>';
	76	+ echo '<td>' , $worksheet->getCell('D'.$row)->getFormattedValue() , '</td>';
	77	+ echo '<td>' , $worksheet->getCell('E'.$row)->getFormattedValue() , '</td>';
	78	+ echo '</tr>';
	79	+ }
	80	+ ?>
81	81	</table>
82	82	\ No newline at end of file

		@@ -33,18 +33,18 @@ discard block
		block discarded – undo
33	33
34	34	// Add some data
35	35	$testDates = array( '3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM'
36		- );
	36	+ );
37	37	$testDateCount = count($testDates);
38	38
39	39	for($row = 1; $row <= $testDateCount; ++$row) {
40		- $worksheet->setCellValue('A'.$row, $testDates[$row-1]);
41		- $worksheet->setCellValue('B'.$row, '=TIMEVALUE(A'.$row.')');
42		- $worksheet->setCellValue('C'.$row, '=B'.$row);
	40	+ $worksheet->setCellValue('A'.$row, $testDates[$row-1]);
	41	+ $worksheet->setCellValue('B'.$row, '=TIMEVALUE(A'.$row.')');
	42	+ $worksheet->setCellValue('C'.$row, '=B'.$row);
43	43	}
44	44
45	45	$worksheet->getStyle('C1:C'.$testDateCount)
46		- ->getNumberFormat()
47		- ->setFormatCode('hh:mm:ss');
	46	+ ->getNumberFormat()
	47	+ ->setFormatCode('hh:mm:ss');
48	48
49	49
50	50	echo '<hr />';
		@@ -60,13 +60,13 @@ discard block
		block discarded – undo
60	60	<th>Formatted TimeStamp</th>
61	61	</tr>
62	62	<?php
63		- for ($row = 1; $row <= $testDateCount; ++$row) {
64		- echo '<tr>';
65		- echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
66		- echo '<td>' , $worksheet->getCell('B'.$row)->getValue() , '</td>';
67		- echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
68		- echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
69		- echo '</tr>';
70		- }
71		- ?>
	63	+ for ($row = 1; $row <= $testDateCount; ++$row) {
	64	+ echo '<tr>';
	65	+ echo '<td>' , $worksheet->getCell('A'.$row)->getFormattedValue() , '</td>';
	66	+ echo '<td>' , $worksheet->getCell('B'.$row)->getValue() , '</td>';
	67	+ echo '<td>' , $worksheet->getCell('B'.$row)->getFormattedValue() , '</td>';
	68	+ echo '<td>' , $worksheet->getCell('C'.$row)->getFormattedValue() , '</td>';
	69	+ echo '</tr>';
	70	+ }
	71	+ ?>
72	72	</table>
73	73	\ No newline at end of file

		@@ -23,27 +23,27 @@
		block discarded – undo
23	23
24	24	foreach($exampleTypeList as $exampleType) {
25	25
26		- echo '<h2>' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Function Examples</h2>';
	26	+ echo '<h2>' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Function Examples</h2>';
27	27
28		- $exampleList = glob('./'.$exampleType.'/*.php');
	28	+ $exampleList = glob('./'.$exampleType.'/*.php');
29	29
30		- foreach($exampleList as $exampleFile) {
31		- $fileData = file_get_contents($exampleFile);
	30	+ foreach($exampleList as $exampleFile) {
	31	+ $fileData = file_get_contents($exampleFile);
32	32
33		- $h1Pattern = '#<h1>(.*?)</h1>#';
34		- $h2Pattern = '#<h2>(.*?)</h2>#';
	33	+ $h1Pattern = '#<h1>(.*?)</h1>#';
	34	+ $h2Pattern = '#<h2>(.*?)</h2>#';
35	35
36		- if (preg_match($h1Pattern, $fileData, $out)) {
37		- $h1Text = $out[1];
38		- $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
	36	+ if (preg_match($h1Pattern, $fileData, $out)) {
	37	+ $h1Text = $out[1];
	38	+ $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
39	39
40		- echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
41		- if ($h2Text > '') {
42		- echo $h2Text,'<br />';
43		- }
44		- }
	40	+ echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
	41	+ if ($h2Text > '') {
	42	+ echo $h2Text,'<br />';
	43	+ }
	44	+ }
45	45
46		- }
	46	+ }
47	47	}
48	48
49	49	?>

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

		@@ -42,7 +42,7 @@
		block discarded – undo
42	42
43	43	echo '<b>Custom Property names: </b><br />';
44	44	foreach($customPropertyList as $customPropertyName) {
45		- echo $customPropertyName,'<br />';
	45	+ echo $customPropertyName,'<br />';
46	46	}
47	47
48	48

		@@ -43,34 +43,34 @@
		block discarded – undo
43	43	echo '<b>Custom Properties: </b><br />';
44	44	/ Loop through the list of custom properties /
45	45	foreach($customPropertyList as $customPropertyName) {
46		- echo '<b>',$customPropertyName,': </b>';
47		- / Retrieve the property value /
48		- $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
49		- / Retrieve the property type /
50		- $propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customPropertyName);
51		-
52		- / Manipulate properties as appropriate for display purposes /
53		- switch($propertyType) {
54		- case 'i' : // integer
55		- $propertyType = 'integer number';
56		- break;
57		- case 'f' : // float
58		- $propertyType = 'floating point number';
59		- break;
60		- case 's' : // string
61		- $propertyType = 'string';
62		- break;
63		- case 'd' : // date
64		- $propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A',$propertyValue);
65		- $propertyType = 'date';
66		- break;
67		- case 'b' : // boolean
68		- $propertyValue = ($propertyValue) ? 'TRUE' : 'FALSE';
69		- $propertyType = 'boolean';
70		- break;
71		- }
72		-
73		- echo $propertyValue,' (',$propertyType,')<br />';
	46	+ echo '<b>',$customPropertyName,': </b>';
	47	+ / Retrieve the property value /
	48	+ $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
	49	+ / Retrieve the property type /
	50	+ $propertyType = $objPHPExcel->getProperties()->getCustomPropertyType($customPropertyName);
	51	+
	52	+ / Manipulate properties as appropriate for display purposes /
	53	+ switch($propertyType) {
	54	+ case 'i' : // integer
	55	+ $propertyType = 'integer number';
	56	+ break;
	57	+ case 'f' : // float
	58	+ $propertyType = 'floating point number';
	59	+ break;
	60	+ case 's' : // string
	61	+ $propertyType = 'string';
	62	+ break;
	63	+ case 'd' : // date
	64	+ $propertyValue = date('l, d<\s\up>S</\s\up> F Y g:i A',$propertyValue);
	65	+ $propertyType = 'date';
	66	+ break;
	67	+ case 'b' : // boolean
	68	+ $propertyValue = ($propertyValue) ? 'TRUE' : 'FALSE';
	69	+ $propertyType = 'boolean';
	70	+ break;
	71	+ }
	72	+
	73	+ echo $propertyValue,' (',$propertyType,')<br />';
74	74	}
75	75
76	76

		@@ -37,15 +37,15 @@
		block discarded – undo
37	37
38	38	class MyReadFilter implements PHPExcel_Reader_IReadFilter
39	39	{
40		- public function readCell($column, $row, $worksheetName = '') {
41		- // Read rows 1 to 7 and columns A to E only
42		- if ($row >= 1 && $row <= 7) {
43		- if (in_array($column,range('A','E'))) {
44		- return true;
45		- }
46		- }
47		- return false;
48		- }
	40	+ public function readCell($column, $row, $worksheetName = '') {
	41	+ // Read rows 1 to 7 and columns A to E only
	42	+ if ($row >= 1 && $row <= 7) {
	43	+ if (in_array($column,range('A','E'))) {
	44	+ return true;
	45	+ }
	46	+ }
	47	+ return false;
	48	+ }
49	49	}
50	50
51	51	$filterSubset = new MyReadFilter();

		@@ -35,10 +35,10 @@ discard block
		block discarded – undo
35	35	$objPHPExcel = $objReader->load($inputFileName);
36	36	$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));
37	37	foreach($inputFileNames as $sheet => $inputFileName) {
38		- echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' into WorkSheet #',($sheet+2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
39		- $objReader->setSheetIndex($sheet+1);
40		- $objReader->loadIntoExisting($inputFileName,$objPHPExcel);
41		- $objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));
	38	+ echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' into WorkSheet #',($sheet+2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
	39	+ $objReader->setSheetIndex($sheet+1);
	40	+ $objReader->loadIntoExisting($inputFileName,$objPHPExcel);
	41	+ $objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));
42	42	}
43	43
44	44
		@@ -47,11 +47,11 @@ discard block
		block discarded – undo
47	47	echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
48	48	$loadedSheetNames = $objPHPExcel->getSheetNames();
49	49	foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {
50		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';
51		- $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
52		- $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
53		- var_dump($sheetData);
54		- echo '<br /><br />';
	50	+ echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';
	51	+ $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
	52	+ $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
	53	+ var_dump($sheetData);
	54	+ echo '<br /><br />';
55	55	}
56	56
57	57

		@@ -39,31 +39,31 @@
		block discarded – undo
39	39	echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
40	40	$loadedSheetNames = $objPHPExcel->getSheetNames();
41	41	foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {
42		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />';
43		- $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
44		- $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
45		- var_dump($sheetData);
46		- echo '<br />';
	42	+ echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />';
	43	+ $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
	44	+ $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
	45	+ var_dump($sheetData);
	46	+ echo '<br />';
47	47	}
48	48
49	49	echo '<hr />';
50	50
51	51	foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {
52		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Unformatted)</b><br />';
53		- $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
54		- $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,false,true);
55		- var_dump($sheetData);
56		- echo '<br />';
	52	+ echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Unformatted)</b><br />';
	53	+ $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
	54	+ $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,false,true);
	55	+ var_dump($sheetData);
	56	+ echo '<br />';
57	57	}
58	58
59	59	echo '<hr />';
60	60
61	61	foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {
62		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Raw)</b><br />';
63		- $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
64		- $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,false,false,true);
65		- var_dump($sheetData);
66		- echo '<br />';
	62	+ echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Raw)</b><br />';
	63	+ $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
	64	+ $sheetData = $objPHPExcel->getActiveSheet()->toArray(null,false,false,true);
	65	+ var_dump($sheetData);
	66	+ echo '<br />';
67	67	}
68	68
69	69	?>

PHPOffice / PhpSpreadsheet

Branch — develop (d19f73)

Category

Indentation +18 added lines, -18 removed lines patch added patch discarded remove patch

Indentation +15 added lines, -15 removed lines patch added patch discarded remove patch

Indentation +15 added lines, -15 removed lines patch added patch discarded remove patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

Indentation +1 added lines, -1 removed lines patch added patch discarded remove patch

Indentation +28 added lines, -28 removed lines patch added patch discarded remove patch

Indentation +9 added lines, -9 removed lines patch added patch discarded remove patch

Indentation +9 added lines, -9 removed lines patch added patch discarded remove patch

Indentation +15 added lines, -15 removed lines patch added patch discarded remove patch