PHPOffice / PhpSpreadsheet

docs/Examples/Reader/exampleReader11.php

Spacing +2 added lines, -2 removed lines

@@ -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);
 
@@ -73,7 +73,7 @@ 
 
 /*  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 />';
     /*  Tell the Read Filter, the limits on which rows we want to read this iteration  **/
     $chunkFilter->setRows($startRow, $chunkSize);
     /*  Load only the rows that match our filter from $inputFileName to a PHPExcel Object  **/

docs/Examples/Reader/exampleReader19.php

Spacing +1 added lines, -1 removed lines

@@ -32,7 +32,7 @@
 //	$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);

docs/Examples/Reader/exampleReader12.php

Spacing +2 added lines, -2 removed lines

@@ -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);
 
@@ -73,7 +73,7 @@ 
 
 /*  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 />';
     /*  Tell the Read Filter, the limits on which rows we want to read this iteration  **/
     $chunkFilter->setRows($startRow, $chunkSize);
     /*  Load only the rows that match our filter from $inputFileName to a PHPExcel Object  **/

docs/Examples/Reader/exampleReader09.php

Spacing +2 added lines, -2 removed lines

@@ -62,9 +62,9 @@
 
 $filterSubset = new MyReadFilter(9, 15, range('G', 'K'));
 
-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 configurable filter<br />';
 $objReader->setReadFilter($filterSubset);

docs/Examples/Reader/exampleReader05.php

Spacing +1 added lines, -1 removed lines

@@ -32,7 +32,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 'Turning Formatting off for Load<br />';
 $objReader->setReadDataOnly(true);

docs/Examples/Reader/exampleReader17.php

Spacing +3 added lines, -3 removed lines

@@ -32,16 +32,16 @@
 //	$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);
 
 /*  Read the list of Worksheet Names from the Workbook file  **/
 echo 'Read the list of Worksheets in the WorkBook<br />';
 $worksheetNames = $objReader->listWorksheetNames($inputFileName);
 
-echo 'There are ',count($worksheetNames),' worksheet',((count($worksheetNames) == 1) ? '' : 's'),' in the workbook<br /><br />';
+echo 'There are ', count($worksheetNames), ' worksheet', ((count($worksheetNames) == 1) ? '' : 's'), ' in the workbook<br /><br />';
 foreach ($worksheetNames as $worksheetName) {
-    echo $worksheetName,'<br />';
+    echo $worksheetName, '<br />';
 }
 
 ?>

docs/Examples/Calculations/index.php

Spacing +2 added lines, -2 removed lines

@@ -34,10 +34,10 @@
             $h1Text = $out[1];
             $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
 
-            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
+            echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';
             if (($h2Text > '') &&
                 (pathinfo($exampleType, PATHINFO_BASENAME) != 'Calculations')) {
-                echo $h2Text,'<br />';
+                echo $h2Text, '<br />';
             }
         }
     }

docs/Examples/Calculations/DateTime/TIME.php

Spacing +9 added lines, -9 removed lines

@@ -30,9 +30,9 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = [[3, 15],        [13, 15],    [15, 15, 15],    [3, 15, 30],
-                    [15, 15, 15],    [5],        [9, 15, 0],        [9, 15, -1],
-                    [13, -14, -15],    [0, 0, -1],
+$testDates = [[3, 15], [13, 15], [15, 15, 15], [3, 15, 30],
+                    [15, 15, 15], [5], [9, 15, 0], [9, 15, -1],
+                    [13, -14, -15], [0, 0, -1],
                   ];
 $testDateCount = count($testDates);
 
@@ -65,12 +65,12 @@ 
 	<?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 '<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>';
     }
     ?>

Indentation +3 added lines, -3 removed lines

@@ -31,7 +31,7 @@ 
 
 // Add some data
 $testDates = ['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) {
@@ -41,8 +41,8 @@ 
 }
 
 $worksheet->getStyle('C1:C' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 echo '<hr />';
 

docs/Examples/Calculations/DateTime/DATEVALUE.php

Spacing +8 added lines, -8 removed lines

@@ -30,10 +30,10 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = ['26 March 2012',    '29 Feb 2012',    'April 1, 2012',    '25/12/2012',
-                    '2012-Oct-31',        '5th November',    'January 1st',        'April 2012',
-                    '17-03',            '03-2012',        '29 Feb 2011',        '03-05-07',
-                    '03-MAY-07',        '03-13-07',
+$testDates = ['26 March 2012', '29 Feb 2012', 'April 1, 2012', '25/12/2012',
+                    '2012-Oct-31', '5th November', 'January 1st', 'April 2012',
+                    '17-03', '03-2012', '29 Feb 2011', '03-05-07',
+                    '03-MAY-07', '03-13-07',
                   ];
 $testDateCount = count($testDates);
 
@@ -62,10 +62,10 @@ 
 	<?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 '<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>';
     }
     ?>

Indentation +3 added lines, -3 removed lines

@@ -35,7 +35,7 @@ 
                     [2011, 2, 29],    [7, 5, 3],        [2012, 13, 1],    [2012, 11, 45],
                     [2012, 0, 0],    [2012, 1, 0],    [2012, 0, 1],
                     [2012, -2, 2],    [2012, 2, -2],    [2012, -2, -2],
-                  ];
+                    ];
 $testDateCount = count($testDates);
 
 $worksheet->fromArray($testDates, null, 'A1', true);
@@ -45,8 +45,8 @@ 
     $worksheet->setCellValue('E' . $row, '=D' . $row);
 }
 $worksheet->getStyle('E1:E' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('yyyy-mmm-dd');
+            ->getNumberFormat()
+            ->setFormatCode('yyyy-mmm-dd');
 
 echo '<hr />';