Inspection of "Exxcel 2003 XML working pattern property (#54)" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 30a5e4...a5c21a )

by Adrien

created 2016-12-14 13:21 UTC

Status

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

@@ -26,17 +26,17 @@  discard block
 block discarded – undo
 $inputFileName = './sampleData/example1.tsv';
 
 $objReader = \PhpOffice\PhpSpreadsheet\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");
 $spreadsheet = $objReader->load($inputFileName);
 $spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));
 
 echo '<hr />';
 
-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
 $loadedSheetNames = $spreadsheet->getSheetNames();
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
-    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />';
+    echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Formatted)</b><br />';
     $spreadsheet->setActiveSheetIndexByName($loadedSheetName);
     $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
     var_dump($sheetData);
@@ -46,7 +46,7 @@  discard block
 block discarded – undo
 echo '<hr />';
 
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
-    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Unformatted)</b><br />';
+    echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Unformatted)</b><br />';
     $spreadsheet->setActiveSheetIndexByName($loadedSheetName);
     $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, false, true);
     var_dump($sheetData);
@@ -56,7 +56,7 @@  discard block
 block discarded – undo
 echo '<hr />';
 
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
-    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Raw)</b><br />';
+    echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Raw)</b><br />';
     $spreadsheet->setActiveSheetIndexByName($loadedSheetName);
     $sheetData = $spreadsheet->getActiveSheet()->toArray(null, false, false, true);
     var_dump($sheetData);

Please login to merge, or discard this patch.

docs/Examples/Reader/exampleReader18.php 1 patch

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

@@ -32,7 +32,7 @@
 block discarded – undo
 //	$inputFileType = 'Gnumeric';
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 $worksheetData = $objReader->listWorksheetInfo($inputFileName);

Please login to merge, or discard this patch.

docs/Examples/Reader/exampleReader14.php 1 patch

Spacing +4 added lines, -4 removed lines patch added patch discarded remove patch

@@ -48,7 +48,7 @@  discard block
 block discarded – undo
     }
 }
 
-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 = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
 
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
 /*  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 />';
+    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);
 
@@ -87,10 +87,10 @@  discard block
 block discarded – undo
 
 echo '<hr />';
 
-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
 $loadedSheetNames = $spreadsheet->getSheetNames();
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
-    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';
+    echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, '</b><br />';
     $spreadsheet->setActiveSheetIndexByName($loadedSheetName);
     $sheetData = $spreadsheet->getActiveSheet()->toArray(null, false, false, true);
     var_dump($sheetData);

Please login to merge, or discard this patch.

docs/Examples/Reader/exampleReader13.php 1 patch

Spacing +4 added lines, -4 removed lines patch added patch discarded remove patch

@@ -30,11 +30,11 @@  discard block
 block discarded – undo
 
 $objReader = \PhpOffice\PhpSpreadsheet\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 />';
 $spreadsheet = $objReader->load($inputFileName);
 $spreadsheet->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 />';
+    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, $spreadsheet);
     $spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));
@@ -42,10 +42,10 @@  discard block
 block discarded – undo
 
 echo '<hr />';
 
-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
 $loadedSheetNames = $spreadsheet->getSheetNames();
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
-    echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';
+    echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, '</b><br />';
     $spreadsheet->setActiveSheetIndexByName($loadedSheetName);
     $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
     var_dump($sheetData);

Please login to merge, or discard this patch.

		@@ -32,7 +32,7 @@
		block discarded – undo
32	32	// $inputFileType = 'Gnumeric';
33	33	$inputFileName = './sampleData/example1.xls';
34	34
35		-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />';
	35	+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />';
36	36
37	37	$objReader = PHPExcel_IOFactory::createReader($inputFileType);
38	38	$worksheetData = $objReader->listWorksheetInfo($inputFileName);

		@@ -48,7 +48,7 @@ discard block
		block discarded – undo
48	48	}
49	49	}
50	50
51		-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
	51	+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
52	52	/* Create a new Reader of the type defined in $inputFileType **/
53	53	$objReader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
54	54
		@@ -72,7 +72,7 @@ discard block
		block discarded – undo
72	72	/* Loop to read our worksheet in "chunk size" blocks **/
73	73	/ $startRow is set to 2 initially because we always read the headings in row #1 /
74	74	for ($startRow = 2; $startRow <= 240; $startRow += $chunkSize) {
75		- echo 'Loading WorkSheet #',($sheet + 1),' using configurable filter for headings row 1 and for rows ',$startRow,' to ',($startRow + $chunkSize - 1),'<br />';
	75	+ echo 'Loading WorkSheet #', ($sheet + 1), ' using configurable filter for headings row 1 and for rows ', $startRow, ' to ', ($startRow + $chunkSize - 1), '<br />';
76	76	/* Tell the Read Filter, the limits on which rows we want to read this iteration **/
77	77	$chunkFilter->setRows($startRow, $chunkSize);
78	78
		@@ -87,10 +87,10 @@ discard block
		block discarded – undo
87	87
88	88	echo '<hr />';
89	89
90		-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
	90	+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
91	91	$loadedSheetNames = $spreadsheet->getSheetNames();
92	92	foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
93		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';
	93	+ echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, '</b><br />';
94	94	$spreadsheet->setActiveSheetIndexByName($loadedSheetName);
95	95	$sheetData = $spreadsheet->getActiveSheet()->toArray(null, false, false, true);
96	96	var_dump($sheetData);

		@@ -26,17 +26,17 @@ discard block
		block discarded – undo
26	26	$inputFileName = './sampleData/example1.tsv';
27	27
28	28	$objReader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
29		-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />';
	29	+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />';
30	30	$objReader->setDelimiter("\t");
31	31	$spreadsheet = $objReader->load($inputFileName);
32	32	$spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));
33	33
34	34	echo '<hr />';
35	35
36		-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
	36	+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
37	37	$loadedSheetNames = $spreadsheet->getSheetNames();
38	38	foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
39		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />';
	39	+ echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Formatted)</b><br />';
40	40	$spreadsheet->setActiveSheetIndexByName($loadedSheetName);
41	41	$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
42	42	var_dump($sheetData);
		@@ -46,7 +46,7 @@ discard block
		block discarded – undo
46	46	echo '<hr />';
47	47
48	48	foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
49		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Unformatted)</b><br />';
	49	+ echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Unformatted)</b><br />';
50	50	$spreadsheet->setActiveSheetIndexByName($loadedSheetName);
51	51	$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, false, true);
52	52	var_dump($sheetData);
		@@ -56,7 +56,7 @@ discard block
		block discarded – undo
56	56	echo '<hr />';
57	57
58	58	foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
59		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Raw)</b><br />';
	59	+ echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Raw)</b><br />';
60	60	$spreadsheet->setActiveSheetIndexByName($loadedSheetName);
61	61	$sheetData = $spreadsheet->getActiveSheet()->toArray(null, false, false, true);
62	62	var_dump($sheetData);

		@@ -30,11 +30,11 @@ discard block
		block discarded – undo
30	30
31	31	$objReader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
32	32	$inputFileName = array_shift($inputFileNames);
33		-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />';
	33	+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />';
34	34	$spreadsheet = $objReader->load($inputFileName);
35	35	$spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));
36	36	foreach ($inputFileNames as $sheet => $inputFileName) {
37		- echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #',($sheet + 2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
	37	+ echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #', ($sheet + 2), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
38	38	$objReader->setSheetIndex($sheet + 1);
39	39	$objReader->loadIntoExisting($inputFileName, $spreadsheet);
40	40	$spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));
		@@ -42,10 +42,10 @@ discard block
		block discarded – undo
42	42
43	43	echo '<hr />';
44	44
45		-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
	45	+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
46	46	$loadedSheetNames = $spreadsheet->getSheetNames();
47	47	foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
48		- echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';
	48	+ echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, '</b><br />';
49	49	$spreadsheet->setActiveSheetIndexByName($loadedSheetName);
50	50	$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
51	51	var_dump($sheetData);

PHPOffice / PhpSpreadsheet

Push — develop ( 30a5e4...a5c21a )

Status

Category

Spacing +5 added lines, -5 removed lines patch added patch discarded remove patch

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

Spacing +4 added lines, -4 removed lines patch added patch discarded remove patch

Spacing +4 added lines, -4 removed lines patch added patch discarded remove patch