View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe
Completed
Push — develop ( f74fde...e6bbc4 )
by Adrien
21:27
created
Status
Category
Toggle Patches
Documentation/Examples/Calculations/Database/DSTDEVP.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $objPHPExcel->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DPRODUCT.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $objPHPExcel->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DMIN.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $objPHPExcel->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DSTDEV.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $objPHPExcel->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/Database/DAVERAGE.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $objPHPExcel->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
Documentation/Examples/Calculations/index.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -36,9 +36,9 @@
 
 block discarded – undo
36 36 
             $h1Text = $out[1];
37 37 
             $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
38 38
39 
-            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
39 
+            echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';
40 40 
             if ($h2Text > '') {
41 
-                echo $h2Text,'<br />';
41 
+                echo $h2Text, '<br />';
42 42 
             }
43 43 
         }
44 44 
     }
Please login to merge, or discard this patch.
Documentation/Examples/Reader/exampleReader03.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch 
@@ -34,7 +34,7 @@
 
 block discarded – undo
34 34 
 //	$inputFileType = 'CSV';
35 35 
 $inputFileName = './sampleData/example1.xls';
36 36
37 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
37 
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
38 38 
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
39 39 
 $objPHPExcel = $objReader->load($inputFileName);
40 40
Please login to merge, or discard this patch.
Documentation/Examples/Reader/exampleReader09.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -50,9 +50,9 @@
 
 block discarded – undo
50 50
51 51 
 $filterSubset = new MyReadFilter();
52 52
53 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';
53 
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';
54 54 
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
55 
-echo 'Loading Sheet "',$sheetname,'" only<br />';
55 
+echo 'Loading Sheet "', $sheetname, '" only<br />';
56 56 
 $objReader->setLoadSheetsOnly($sheetname);
57 57 
 echo 'Loading Sheet using filter<br />';
58 58 
 $objReader->setReadFilter($filterSubset);
Please login to merge, or discard this patch.
Documentation/Examples/Reader/exampleReader15.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch 
@@ -26,17 +26,17 @@  discard block
 
 block discarded – undo
26 26 
 $inputFileName = './sampleData/example1.tsv';
27 27
28 28 
 $objReader = PHPExcel_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 
 $objPHPExcel = $objReader->load($inputFileName);
32 32 
 $objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));
33 33
34 34 
 echo '<hr />';
35 35
36 
-echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
36 
+echo $objPHPExcel->getSheetCount(), ' worksheet', (($objPHPExcel->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
37 37 
 $loadedSheetNames = $objPHPExcel->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 
     $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
41 41 
     $sheetData = $objPHPExcel->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 
     $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
51 51 
     $sheetData = $objPHPExcel->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 
     $objPHPExcel->setActiveSheetIndexByName($loadedSheetName);
61 61 
     $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, false, false, true);
62 62 
     var_dump($sheetData);
Please login to merge, or discard this patch.